/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / 14-tutor.er1

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 56 32 2e 34 30 20 45 52 | 77 69 00 00 00 00 ac c2 |V2.40 ER|wi......|
|00000010| 00 00 b4 c2 00 00 01 00 | 00 00 01 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 01 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 15 00 00 00 00 00 |........|........|
|00000050| 01 00 00 00 00 00 00 00 | ac 00 00 00 5b 1b 00 00 |........|....[...|
|00000060| 00 00 00 00 19 00 00 00 | 09 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 06 00 00 00 | 01 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 02 00 40 00 | 32 00 00 00 28 c3 00 00 |......@.|2...(...|
|00000090| 14 00 00 00 b0 c2 00 00 | 32 00 00 00 00 00 00 00 |........|2.......|
|000000a0| 0a 00 08 00 63 68 61 72 | 28 31 38 29 00 00 00 00 |....char|(18)....|
|000000b0| 00 00 00 00 00 00 13 00 | 58 25 4b 65 79 54 79 70 |........|X%KeyTyp|
|000000c0| 65 25 54 61 62 6c 65 4e | 61 6d 65 00 00 00 00 00 |e%TableN|ame.....|
|000000d0| 00 01 00 00 00 00 00 02 | 00 00 00 00 00 07 00 4e |........|.......N|
|000000e0| 6f 74 65 20 49 44 ff ff | 00 00 00 01 00 09 00 4e |ote ID..|.......N|
|000000f0| 6f 74 65 20 54 65 78 74 | ff ff 00 00 00 00 00 00 |ote Text|........|
|00000100| 00 0c 00 00 00 01 00 00 | 00 19 00 00 00 00 01 00 |........|........|
|00000110| 00 00 1a 00 00 00 00 01 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 14 00 00 |........|........|
|00000130| 00 00 02 00 00 00 1a 00 | 00 00 00 02 00 00 00 00 |........|........|
|00000140| 00 00 00 00 04 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000150| 00 00 00 00 00 00 01 00 | 00 00 00 00 00 00 00 01 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 02 00 00 00 00 00 00 00 |........|........|
|00000170| 00 01 00 00 00 00 00 00 | 00 08 00 00 00 01 00 00 |........|........|
|00000180| 00 1e 00 00 00 00 01 00 | 00 00 32 00 00 00 00 01 |........|..2.....|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 02 00 00 00 00 00 00 | 00 00 04 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 04 00 00 00 00 | 00 00 00 00 02 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 0a 00 00 | 00 08 00 00 00 11 00 43 |........|.......C|
|000001d0| 55 52 52 45 4e 54 5f 54 | 49 4d 45 53 54 41 4d 50 |URRENT_T|IMESTAMP|
|000001e0| 11 00 43 55 52 52 45 4e | 54 5f 54 49 4d 45 53 54 |..CURREN|T_TIMEST|
|000001f0| 41 4d 50 00 00 03 00 00 | 00 00 00 00 00 00 00 00 |AMP.....|........|
|00000200| 00 08 00 00 00 0c 00 43 | 55 52 52 45 4e 54 5f 55 |.......C|URRENT_U|
|00000210| 53 45 52 0c 00 43 55 52 | 52 45 4e 54 5f 55 53 45 |SER..CUR|RENT_USE|
|00000220| 52 00 00 03 00 00 00 00 | 00 00 00 00 00 00 00 08 |R.......|........|
|00000230| 00 00 00 10 00 46 69 6c | 6c 20 57 69 74 68 20 53 |.....Fil|l With S|
|00000240| 70 61 63 65 73 00 00 06 | 00 73 70 61 63 65 73 00 |paces...|.spaces.|
|00000250| 00 00 00 00 00 00 00 00 | 00 00 00 08 00 00 00 04 |........|........|
|00000260| 00 4e 55 4c 4c 04 00 4e | 55 4c 4c 00 00 03 00 00 |.NULL..N|ULL.....|
|00000270| 00 00 00 00 00 00 00 00 | 00 08 00 00 00 0c 00 53 |........|.......S|
|00000280| 45 53 53 49 4f 4e 5f 55 | 53 45 52 0c 00 53 45 53 |ESSION_U|SER..SES|
|00000290| 53 49 4f 4e 5f 55 53 45 | 52 00 00 03 00 00 00 00 |SION_USE|R.......|
|000002a0| 00 00 00 00 00 00 00 08 | 00 00 00 13 00 53 65 74 |........|.....Set|
|000002b0| 20 54 6f 20 45 6d 70 74 | 79 20 53 74 72 69 6e 67 | To Empt|y String|
|000002c0| 00 00 05 00 65 6d 70 74 | 79 00 00 00 00 00 00 00 |....empt|y.......|
|000002d0| 00 00 00 00 00 08 00 00 | 00 0b 00 53 65 74 20 54 |........|...Set T|
|000002e0| 6f 20 4e 75 6c 6c 00 00 | 04 00 6e 75 6c 6c 00 00 |o Null..|..null..|
|000002f0| 00 00 00 00 00 00 00 00 | 00 00 08 00 00 00 0b 00 |........|........|
|00000300| 53 65 74 20 54 6f 20 5a | 65 72 6f 00 00 01 00 30 |Set To Z|ero....0|
|00000310| 00 00 00 00 00 00 00 00 | 00 00 00 00 08 00 00 00 |........|........|
|00000320| 04 00 55 53 45 52 04 00 | 55 53 45 52 00 00 03 00 |..USER..|USER....|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 05 00 00 00 01 00 0d 00 | 54 65 6d 70 6c 61 74 65 |........|Template|
|00000350| 20 4e 61 6d 65 22 00 00 | 00 00 01 00 0d 00 54 65 | Name"..|......Te|
|00000360| 6d 70 6c 61 74 65 20 43 | 6f 64 65 00 00 00 00 00 |mplate C|ode.....|
|00000370| 00 00 0d 00 54 65 6d 70 | 6c 61 74 65 20 54 79 70 |....Temp|late Typ|
|00000380| 65 00 00 00 00 00 00 00 | 0f 00 54 65 6d 70 6c 61 |e.......|..Templa|
|00000390| 74 65 20 43 53 58 20 49 | 64 00 00 00 00 00 02 00 |te CSX I|d.......|
|000003a0| 00 00 00 00 00 00 00 24 | 00 00 00 05 00 00 00 16 |.......$|........|
|000003b0| 00 50 41 52 45 4e 54 20 | 55 50 44 41 54 45 20 52 |.PARENT |UPDATE R|
|000003c0| 45 53 54 52 49 43 54 f7 | 01 20 20 2f 2a 20 45 52 |ESTRICT.|.  /* ER|
|000003d0| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|000003e0| 65 74 69 6d 65 20 2a 2f | 0d 0a 20 20 2f 2a 20 25 |etime */|..  /* %|
|000003f0| 50 61 72 65 6e 74 20 25 | 56 65 72 62 50 68 72 61 |Parent %|VerbPhra|
|00000400| 73 65 20 25 43 68 69 6c | 64 20 4f 4e 20 50 41 52 |se %Chil|d ON PAR|
|00000410| 45 4e 54 20 55 50 44 41 | 54 45 20 52 45 53 54 52 |ENT UPDA|TE RESTR|
|00000420| 49 43 54 20 2a 2f 0d 0a | 20 20 69 66 0d 0a 20 20 |ICT */..|  if..  |
|00000430| 20 20 2f 2a 20 25 25 50 | 61 72 65 6e 74 50 4b 28 |  /* %%P|arentPK(|
|00000440| 22 20 6f 72 22 2c 75 70 | 64 61 74 65 29 20 2a 2f |" or",up|date) */|
|00000450| 0d 0a 20 20 20 20 25 50 | 61 72 65 6e 74 50 4b 28 |..    %P|arentPK(|
|00000460| 22 20 6f 72 22 2c 75 70 | 64 61 74 65 29 0d 0a 20 |" or",up|date).. |
|00000470| 20 62 65 67 69 6e 0d 0a | 20 20 20 20 69 66 20 65 | begin..|    if e|
|00000480| 78 69 73 74 73 20 28 0d | 0a 20 20 20 20 20 20 73 |xists (.|.      s|
|00000490| 65 6c 65 63 74 20 2a 20 | 66 72 6f 6d 20 64 65 6c |elect * |from del|
|000004a0| 65 74 65 64 2c 25 43 68 | 69 6c 64 0d 0a 20 20 20 |eted,%Ch|ild..   |
|000004b0| 20 20 20 77 68 65 72 65 | 0d 0a 20 20 20 20 20 20 |   where|..      |
|000004c0| 20 20 2f 2a 20 20 25 25 | 4a 6f 69 6e 46 4b 50 4b |  /*  %%|JoinFKPK|
|000004d0| 28 25 43 68 69 6c 64 2c | 64 65 6c 65 74 65 64 2c |(%Child,|deleted,|
|000004e0| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|000004f0| 0d 0a 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 |..      |  %JoinF|
|00000500| 4b 50 4b 28 25 43 68 69 | 6c 64 2c 64 65 6c 65 74 |KPK(%Chi|ld,delet|
|00000510| 65 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ed," = "|," and")|
|00000520| 0d 0a 20 20 20 20 29 0d | 0a 20 20 20 20 62 65 67 |..    ).|.    beg|
|00000530| 69 6e 0d 0a 20 20 20 20 | 20 20 73 65 6c 65 63 74 |in..    |  select|
|00000540| 20 40 65 72 72 6e 6f 20 | 20 3d 20 33 30 30 30 35 | @errno | = 30005|
|00000550| 2c 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,..     |        |
|00000560| 40 65 72 72 6d 73 67 20 | 3d 20 27 43 61 6e 6e 6f |@errmsg |= 'Canno|
|00000570| 74 20 55 50 44 41 54 45 | 20 22 25 50 61 72 65 6e |t UPDATE| "%Paren|
|00000580| 74 22 20 62 65 63 61 75 | 73 65 20 22 25 43 68 69 |t" becau|se "%Chi|
|00000590| 6c 64 22 20 65 78 69 73 | 74 73 2e 27 0d 0a 20 20 |ld" exis|ts.'..  |
|000005a0| 20 20 20 20 67 6f 74 6f | 20 65 72 72 6f 72 0d 0a |    goto| error..|
|000005b0| 20 20 20 20 65 6e 64 0d | 0a 20 20 65 6e 64 0d 0a |    end.|.  end..|
|000005c0| 10 27 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |.'......|........|
|000005d0| 15 00 50 41 52 45 4e 54 | 20 55 50 44 41 54 45 20 |..PARENT| UPDATE |
|000005e0| 43 41 53 43 41 44 45 f1 | 02 20 20 2f 2a 20 45 52 |CASCADE.|.  /* ER|
|000005f0| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|00000600| 65 74 69 6d 65 20 2a 2f | 0d 0a 20 20 2f 2a 20 25 |etime */|..  /* %|
|00000610| 50 61 72 65 6e 74 20 25 | 56 65 72 62 50 68 72 61 |Parent %|VerbPhra|
|00000620| 73 65 20 25 43 68 69 6c | 64 20 4f 4e 20 50 41 52 |se %Chil|d ON PAR|
|00000630| 45 4e 54 20 55 50 44 41 | 54 45 20 43 41 53 43 41 |ENT UPDA|TE CASCA|
|00000640| 44 45 20 2a 2f 0d 0a 20 | 20 69 66 0d 0a 20 20 20 |DE */.. | if..   |
|00000650| 20 2f 2a 20 25 25 50 61 | 72 65 6e 74 50 4b 28 22 | /* %%Pa|rentPK("|
|00000660| 20 6f 72 22 2c 75 70 64 | 61 74 65 29 20 2a 2f 0d | or",upd|ate) */.|
|00000670| 0a 20 20 20 20 25 50 61 | 72 65 6e 74 50 4b 28 22 |.    %Pa|rentPK("|
|00000680| 20 6f 72 22 2c 75 70 64 | 61 74 65 29 0d 0a 20 20 | or",upd|ate)..  |
|00000690| 62 65 67 69 6e 0d 0a 20 | 20 20 20 69 66 20 40 6e |begin.. |   if @n|
|000006a0| 75 6d 72 6f 77 73 20 3d | 20 31 0d 0a 20 20 20 20 |umrows =| 1..    |
|000006b0| 62 65 67 69 6e 0d 0a 20 | 20 20 20 20 20 73 65 6c |begin.. |     sel|
|000006c0| 65 63 74 20 25 4a 6f 69 | 6e 50 4b 50 4b 28 40 69 |ect %Joi|nPKPK(@i|
|000006d0| 6e 73 2c 69 6e 73 65 72 | 74 65 64 2c 22 20 3d 20 |ns,inser|ted," = |
|000006e0| 22 2c 22 2c 20 22 29 0d | 0a 20 20 20 20 20 20 20 |",", ").|.       |
|000006f0| 20 66 72 6f 6d 20 69 6e | 73 65 72 74 65 64 0d 0a | from in|serted..|
|00000700| 20 20 20 20 20 20 75 70 | 64 61 74 65 20 25 43 68 |      up|date %Ch|
|00000710| 69 6c 64 0d 0a 20 20 20 | 20 20 20 73 65 74 0d 0a |ild..   |   set..|
|00000720| 20 20 20 20 20 20 20 20 | 2f 2a 20 20 25 25 4a 6f |        |/*  %%Jo|
|00000730| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 40 69 |inFKPK(%|Child,@i|
|00000740| 6e 73 2c 22 20 3d 20 22 | 2c 22 2c 22 29 20 2a 2f |ns," = "|,",") */|
|00000750| 0d 0a 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 |..      |  %JoinF|
|00000760| 4b 50 4b 28 25 43 68 69 | 6c 64 2c 40 69 6e 73 2c |KPK(%Chi|ld,@ins,|
|00000770| 22 20 3d 20 22 2c 22 2c | 22 29 0d 0a 20 20 20 20 |" = ",",|")..    |
|00000780| 20 20 66 72 6f 6d 20 25 | 43 68 69 6c 64 2c 69 6e |  from %|Child,in|
|00000790| 73 65 72 74 65 64 2c 64 | 65 6c 65 74 65 64 0d 0a |serted,d|eleted..|
|000007a0| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 |      wh|ere..   |
|000007b0| 20 20 20 20 20 2f 2a 20 | 20 25 25 4a 6f 69 6e 46 |     /* | %%JoinF|
|000007c0| 4b 50 4b 28 25 43 68 69 | 6c 64 2c 64 65 6c 65 74 |KPK(%Chi|ld,delet|
|000007d0| 65 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ed," = "|," and")|
|000007e0| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 25 4a 6f | */..   |     %Jo|
|000007f0| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 64 65 |inFKPK(%|Child,de|
|00000800| 6c 65 74 65 64 2c 22 20 | 3d 20 22 2c 22 20 61 6e |leted," |= "," an|
|00000810| 64 22 29 0d 0a 20 20 20 | 20 65 6e 64 0d 0a 20 20 |d")..   | end..  |
|00000820| 20 20 65 6c 73 65 0d 0a | 20 20 20 20 62 65 67 69 |  else..|    begi|
|00000830| 6e 0d 0a 20 20 20 20 20 | 20 73 65 6c 65 63 74 20 |n..     | select |
|00000840| 40 65 72 72 6e 6f 20 3d | 20 33 30 30 30 36 2c 0d |@errno =| 30006,.|
|00000850| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 40 65 |.       |      @e|
|00000860| 72 72 6d 73 67 20 3d 20 | 27 43 61 6e 6e 6f 74 20 |rrmsg = |'Cannot |
|00000870| 63 61 73 63 61 64 65 20 | 22 25 50 61 72 65 6e 74 |cascade |"%Parent|
|00000880| 22 20 55 50 44 41 54 45 | 20 62 65 63 61 75 73 65 |" UPDATE| because|
|00000890| 20 6d 6f 72 65 20 74 68 | 61 6e 20 6f 6e 65 20 72 | more th|an one r|
|000008a0| 6f 77 20 68 61 73 20 62 | 65 65 6e 20 61 66 66 65 |ow has b|een affe|
|000008b0| 63 74 65 64 2e 27 0d 0a | 20 20 20 20 20 20 67 6f |cted.'..|      go|
|000008c0| 74 6f 20 65 72 72 6f 72 | 0d 0a 20 20 20 20 65 6e |to error|..    en|
|000008d0| 64 0d 0a 20 20 65 6e 64 | 0d 0a 11 27 00 00 00 00 |d..  end|...'....|
|000008e0| 00 00 00 00 00 00 05 00 | 00 00 16 00 50 41 52 45 |........|....PARE|
|000008f0| 4e 54 20 55 50 44 41 54 | 45 20 53 45 54 20 4e 55 |NT UPDAT|E SET NU|
|00000900| 4c 4c a4 01 20 20 2f 2a | 20 45 52 77 69 6e 20 42 |LL..  /*| ERwin B|
|00000910| 75 69 6c 74 69 6e 20 25 | 44 61 74 65 74 69 6d 65 |uiltin %|Datetime|
|00000920| 20 2a 2f 0d 0a 20 20 2f | 2a 20 25 50 61 72 65 6e | */..  /|* %Paren|
|00000930| 74 20 25 56 65 72 62 50 | 68 72 61 73 65 20 25 43 |t %VerbP|hrase %C|
|00000940| 68 69 6c 64 20 4f 4e 20 | 50 41 52 45 4e 54 20 55 |hild ON |PARENT U|
|00000950| 50 44 41 54 45 20 53 45 | 54 20 4e 55 4c 4c 20 2a |PDATE SE|T NULL *|
|00000960| 2f 0d 0a 20 20 69 66 0d | 0a 20 20 20 20 2f 2a 20 |/..  if.|.    /* |
|00000970| 25 25 50 61 72 65 6e 74 | 50 4b 28 22 20 6f 72 22 |%%Parent|PK(" or"|
|00000980| 2c 75 70 64 61 74 65 29 | 20 2a 2f 0d 0a 20 20 20 |,update)| */..   |
|00000990| 20 25 50 61 72 65 6e 74 | 50 4b 28 22 20 6f 72 22 | %Parent|PK(" or"|
|000009a0| 2c 75 70 64 61 74 65 29 | 0d 0a 20 20 62 65 67 69 |,update)|..  begi|
|000009b0| 6e 0d 0a 20 20 20 20 75 | 70 64 61 74 65 20 25 43 |n..    u|pdate %C|
|000009c0| 68 69 6c 64 0d 0a 20 20 | 20 20 20 20 73 65 74 0d |hild..  |    set.|
|000009d0| 0a 20 20 20 20 20 20 20 | 20 2f 2a 20 25 25 53 65 |.       | /* %%Se|
|000009e0| 74 46 4b 28 25 43 68 69 | 6c 64 2c 4e 55 4c 4c 29 |tFK(%Chi|ld,NULL)|
|000009f0| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 25 53 65 | */..   |     %Se|
|00000a00| 74 46 4b 28 25 43 68 69 | 6c 64 2c 4e 55 4c 4c 29 |tFK(%Chi|ld,NULL)|
|00000a10| 0d 0a 20 20 20 20 20 20 | 66 72 6f 6d 20 25 43 68 |..      |from %Ch|
|00000a20| 69 6c 64 2c 64 65 6c 65 | 74 65 64 0d 0a 20 20 20 |ild,dele|ted..   |
|00000a30| 20 20 20 77 68 65 72 65 | 0d 0a 20 20 20 20 20 20 |   where|..      |
|00000a40| 20 20 2f 2a 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 |  /* %%J|oinFKPK(|
|00000a50| 25 43 68 69 6c 64 2c 64 | 65 6c 65 74 65 64 2c 22 |%Child,d|eleted,"|
|00000a60| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d | = "," a|nd") */.|
|00000a70| 0a 20 20 20 20 20 20 20 | 20 25 4a 6f 69 6e 46 4b |.       | %JoinFK|
|00000a80| 50 4b 28 25 43 68 69 6c | 64 2c 64 65 6c 65 74 65 |PK(%Chil|d,delete|
|00000a90| 64 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 0d |d," = ",|" and").|
|00000aa0| 0a 20 20 65 6e 64 0d 0a | 12 27 00 00 00 00 00 00 |.  end..|.'......|
|00000ab0| 00 00 00 00 05 00 00 00 | 16 00 50 41 52 45 4e 54 |........|..PARENT|
|00000ac0| 20 44 45 4c 45 54 45 20 | 52 45 53 54 52 49 43 54 | DELETE |RESTRICT|
|00000ad0| a4 01 20 20 20 20 2f 2a | 20 45 52 77 69 6e 20 42 |..    /*| ERwin B|
|00000ae0| 75 69 6c 74 69 6e 20 25 | 44 61 74 65 74 69 6d 65 |uiltin %|Datetime|
|00000af0| 20 2a 2f 0d 0a 20 20 20 | 20 2f 2a 20 25 50 61 72 | */..   | /* %Par|
|00000b00| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00000b10| 25 43 68 69 6c 64 20 4f | 4e 20 50 41 52 45 4e 54 |%Child O|N PARENT|
|00000b20| 20 44 45 4c 45 54 45 20 | 52 45 53 54 52 49 43 54 | DELETE |RESTRICT|
|00000b30| 20 2a 2f 0d 0a 20 20 20 | 20 69 66 20 65 78 69 73 | */..   | if exis|
|00000b40| 74 73 20 28 0d 0a 20 20 | 20 20 20 20 73 65 6c 65 |ts (..  |    sele|
|00000b50| 63 74 20 2a 20 66 72 6f | 6d 20 64 65 6c 65 74 65 |ct * fro|m delete|
|00000b60| 64 2c 25 43 68 69 6c 64 | 0d 0a 20 20 20 20 20 20 |d,%Child|..      |
|00000b70| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 2f |where.. |       /|
|00000b80| 2a 20 20 25 25 4a 6f 69 | 6e 46 4b 50 4b 28 25 43 |*  %%Joi|nFKPK(%C|
|00000b90| 68 69 6c 64 2c 64 65 6c | 65 74 65 64 2c 22 20 3d |hild,del|eted," =|
|00000ba0| 20 22 2c 22 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 | "," and|") */.. |
|00000bb0| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b |       %|JoinFKPK|
|00000bc0| 28 25 43 68 69 6c 64 2c | 64 65 6c 65 74 65 64 2c |(%Child,|deleted,|
|00000bd0| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 0d 0a 20 |" = "," |and").. |
|00000be0| 20 20 20 29 0d 0a 20 20 | 20 20 62 65 67 69 6e 0d |   )..  |  begin.|
|00000bf0| 0a 20 20 20 20 20 20 73 | 65 6c 65 63 74 20 40 65 |.      s|elect @e|
|00000c00| 72 72 6e 6f 20 20 3d 20 | 33 30 30 30 31 2c 0d 0a |rrno  = |30001,..|
|00000c10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 40 65 72 |        |     @er|
|00000c20| 72 6d 73 67 20 3d 20 27 | 43 61 6e 6e 6f 74 20 44 |rmsg = '|Cannot D|
|00000c30| 45 4c 45 54 45 20 22 25 | 50 61 72 65 6e 74 22 20 |ELETE "%|Parent" |
|00000c40| 62 65 63 61 75 73 65 20 | 22 25 43 68 69 6c 64 22 |because |"%Child"|
|00000c50| 20 65 78 69 73 74 73 2e | 27 0d 0a 20 20 20 20 20 | exists.|'..     |
|00000c60| 20 67 6f 74 6f 20 65 72 | 72 6f 72 0d 0a 20 20 20 | goto er|ror..   |
|00000c70| 20 65 6e 64 0d 0a 14 27 | 00 00 00 00 00 00 00 00 | end...'|........|
|00000c80| 00 00 05 00 00 00 15 00 | 50 41 52 45 4e 54 20 44 |........|PARENT D|
|00000c90| 45 4c 45 54 45 20 43 41 | 53 43 41 44 45 05 01 20 |ELETE CA|SCADE.. |
|00000ca0| 20 20 20 2f 2a 20 45 52 | 77 69 6e 20 42 75 69 6c |   /* ER|win Buil|
|00000cb0| 74 69 6e 20 25 44 61 74 | 65 74 69 6d 65 20 2a 2f |tin %Dat|etime */|
|00000cc0| 0d 0a 20 20 20 20 2f 2a | 20 25 50 61 72 65 6e 74 |..    /*| %Parent|
|00000cd0| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00000ce0| 69 6c 64 20 4f 4e 20 50 | 41 52 45 4e 54 20 44 45 |ild ON P|ARENT DE|
|00000cf0| 4c 45 54 45 20 43 41 53 | 43 41 44 45 20 2a 2f 0d |LETE CAS|CADE */.|
|00000d00| 0a 20 20 20 20 64 65 6c | 65 74 65 20 25 43 68 69 |.    del|ete %Chi|
|00000d10| 6c 64 0d 0a 20 20 20 20 | 20 20 66 72 6f 6d 20 25 |ld..    |  from %|
|00000d20| 43 68 69 6c 64 2c 64 65 | 6c 65 74 65 64 0d 0a 20 |Child,de|leted.. |
|00000d30| 20 20 20 20 20 77 68 65 | 72 65 0d 0a 20 20 20 20 |     whe|re..    |
|00000d40| 20 20 20 20 2f 2a 20 20 | 25 25 4a 6f 69 6e 46 4b |    /*  |%%JoinFK|
|00000d50| 50 4b 28 25 43 68 69 6c | 64 2c 64 65 6c 65 74 65 |PK(%Chil|d,delete|
|00000d60| 64 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 20 |d," = ",|" and") |
|00000d70| 2a 2f 0d 0a 20 20 20 20 | 20 20 20 20 25 4a 6f 69 |*/..    |    %Joi|
|00000d80| 6e 46 4b 50 4b 28 25 43 | 68 69 6c 64 2c 64 65 6c |nFKPK(%C|hild,del|
|00000d90| 65 74 65 64 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |eted," =| "," and|
|00000da0| 22 29 0d 0a 15 27 00 00 | 00 00 00 00 00 00 00 00 |")...'..|........|
|00000db0| 05 00 00 00 16 00 50 41 | 52 45 4e 54 20 44 45 4c |......PA|RENT DEL|
|00000dc0| 45 54 45 20 53 45 54 20 | 4e 55 4c 4c 51 01 20 20 |ETE SET |NULLQ.  |
|00000dd0| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |  /* ERw|in Built|
|00000de0| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00000df0| 0a 20 20 20 20 2f 2a 20 | 25 50 61 72 65 6e 74 20 |.    /* |%Parent |
|00000e00| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00000e10| 6c 64 20 4f 4e 20 50 41 | 52 45 4e 54 20 44 45 4c |ld ON PA|RENT DEL|
|00000e20| 45 54 45 20 53 45 54 20 | 4e 55 4c 4c 20 2a 2f 0d |ETE SET |NULL */.|
|00000e30| 0a 20 20 20 20 75 70 64 | 61 74 65 20 25 43 68 69 |.    upd|ate %Chi|
|00000e40| 6c 64 0d 0a 20 20 20 20 | 20 20 73 65 74 0d 0a 20 |ld..    |  set.. |
|00000e50| 20 20 20 20 20 20 20 2f | 2a 20 25 25 53 65 74 46 |       /|* %%SetF|
|00000e60| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 20 2a |K(%Child|,NULL) *|
|00000e70| 2f 0d 0a 20 20 20 20 20 | 20 20 20 25 53 65 74 46 |/..     |   %SetF|
|00000e80| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 0d 0a |K(%Child|,NULL)..|
|00000e90| 20 20 20 20 20 20 66 72 | 6f 6d 20 25 43 68 69 6c |      fr|om %Chil|
|00000ea0| 64 2c 64 65 6c 65 74 65 | 64 0d 0a 20 20 20 20 20 |d,delete|d..     |
|00000eb0| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|00000ec0| 2f 2a 20 25 25 4a 6f 69 | 6e 46 4b 50 4b 28 25 43 |/* %%Joi|nFKPK(%C|
|00000ed0| 68 69 6c 64 2c 64 65 6c | 65 74 65 64 2c 22 20 3d |hild,del|eted," =|
|00000ee0| 20 22 2c 22 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 | "," and|") */.. |
|00000ef0| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b |       %|JoinFKPK|
|00000f00| 28 25 43 68 69 6c 64 2c | 64 65 6c 65 74 65 64 2c |(%Child,|deleted,|
|00000f10| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 0d 0a 16 |" = "," |and")...|
|00000f20| 27 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 15 |'.......|........|
|00000f30| 00 43 48 49 4c 44 20 49 | 4e 53 45 52 54 20 52 45 |.CHILD I|NSERT RE|
|00000f40| 53 54 52 49 43 54 f0 02 | 20 20 2f 2a 20 45 52 77 |STRICT..|  /* ERw|
|00000f50| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00000f60| 74 69 6d 65 20 2a 2f 0d | 0a 20 20 2f 2a 20 25 50 |time */.|.  /* %P|
|00000f70| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|00000f80| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 43 48 49 4c |e %Child| ON CHIL|
|00000f90| 44 20 49 4e 53 45 52 54 | 20 52 45 53 54 52 49 43 |D INSERT| RESTRIC|
|00000fa0| 54 20 2a 2f 0d 0a 20 20 | 69 66 0d 0a 20 20 20 20 |T */..  |if..    |
|00000fb0| 2f 2a 20 25 25 43 68 69 | 6c 64 46 4b 28 22 20 6f |/* %%Chi|ldFK(" o|
|00000fc0| 72 22 2c 75 70 64 61 74 | 65 29 20 2a 2f 0d 0a 20 |r",updat|e) */.. |
|00000fd0| 20 20 20 25 43 68 69 6c | 64 46 4b 28 22 20 6f 72 |   %Chil|dFK(" or|
|00000fe0| 22 2c 75 70 64 61 74 65 | 29 0d 0a 20 20 62 65 67 |",update|)..  beg|
|00000ff0| 69 6e 0d 0a 20 20 20 20 | 73 65 6c 65 63 74 20 40 |in..    |select @|
|00001000| 6e 75 6c 6c 63 6e 74 20 | 3d 20 30 0d 0a 20 20 20 |nullcnt |= 0..   |
|00001010| 20 73 65 6c 65 63 74 20 | 40 76 61 6c 69 64 63 6e | select |@validcn|
|00001020| 74 20 3d 20 63 6f 75 6e | 74 28 2a 29 0d 0a 20 20 |t = coun|t(*)..  |
|00001030| 20 20 20 20 66 72 6f 6d | 20 69 6e 73 65 72 74 65 |    from| inserte|
|00001040| 64 2c 25 50 61 72 65 6e | 74 0d 0a 20 20 20 20 20 |d,%Paren|t..     |
|00001050| 20 20 20 77 68 65 72 65 | 0d 0a 20 20 20 20 20 20 |   where|..      |
|00001060| 20 20 20 20 2f 2a 20 25 | 25 4a 6f 69 6e 46 4b 50 |    /* %|%JoinFKP|
|00001070| 4b 28 69 6e 73 65 72 74 | 65 64 2c 25 50 61 72 65 |K(insert|ed,%Pare|
|00001080| 6e 74 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |nt) */..|        |
|00001090| 20 20 25 4a 6f 69 6e 46 | 4b 50 4b 28 69 6e 73 65 |  %JoinF|KPK(inse|
|000010a0| 72 74 65 64 2c 25 50 61 | 72 65 6e 74 29 0d 0a 20 |rted,%Pa|rent).. |
|000010b0| 20 20 20 2f 2a 20 25 25 | 4e 6f 74 6e 75 6c 6c 46 |   /* %%|NotnullF|
|000010c0| 4b 28 69 6e 73 65 72 74 | 65 64 2c 22 20 69 73 20 |K(insert|ed," is |
|000010d0| 6e 75 6c 6c 22 2c 22 73 | 65 6c 65 63 74 20 40 6e |null","s|elect @n|
|000010e0| 75 6c 6c 63 6e 74 20 3d | 20 63 6f 75 6e 74 28 2a |ullcnt =| count(*|
|000010f0| 29 20 66 72 6f 6d 20 69 | 6e 73 65 72 74 65 64 20 |) from i|nserted |
|00001100| 77 68 65 72 65 22 2c 22 | 20 61 6e 64 22 29 20 2a |where","| and") *|
|00001110| 2f 0d 0a 20 20 20 20 25 | 4e 6f 74 6e 75 6c 6c 46 |/..    %|NotnullF|
|00001120| 4b 28 69 6e 73 65 72 74 | 65 64 2c 22 20 69 73 20 |K(insert|ed," is |
|00001130| 6e 75 6c 6c 22 2c 22 73 | 65 6c 65 63 74 20 40 6e |null","s|elect @n|
|00001140| 75 6c 6c 63 6e 74 20 3d | 20 63 6f 75 6e 74 28 2a |ullcnt =| count(*|
|00001150| 29 20 66 72 6f 6d 20 69 | 6e 73 65 72 74 65 64 20 |) from i|nserted |
|00001160| 77 68 65 72 65 22 2c 22 | 20 61 6e 64 22 29 0d 0a |where","| and")..|
|00001170| 20 20 20 20 69 66 20 40 | 76 61 6c 69 64 63 6e 74 |    if @|validcnt|
|00001180| 20 2b 20 40 6e 75 6c 6c | 63 6e 74 20 21 3d 20 40 | + @null|cnt != @|
|00001190| 6e 75 6d 72 6f 77 73 0d | 0a 20 20 20 20 62 65 67 |numrows.|.    beg|
|000011a0| 69 6e 0d 0a 20 20 20 20 | 20 20 73 65 6c 65 63 74 |in..    |  select|
|000011b0| 20 40 65 72 72 6e 6f 20 | 20 3d 20 33 30 30 30 32 | @errno | = 30002|
|000011c0| 2c 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,..     |        |
|000011d0| 40 65 72 72 6d 73 67 20 | 3d 20 27 43 61 6e 6e 6f |@errmsg |= 'Canno|
|000011e0| 74 20 49 4e 53 45 52 54 | 20 22 25 43 68 69 6c 64 |t INSERT| "%Child|
|000011f0| 22 20 62 65 63 61 75 73 | 65 20 22 25 50 61 72 65 |" becaus|e "%Pare|
|00001200| 6e 74 22 20 64 6f 65 73 | 20 6e 6f 74 20 65 78 69 |nt" does| not exi|
|00001210| 73 74 2e 27 0d 0a 20 20 | 20 20 20 20 67 6f 74 6f |st.'..  |    goto|
|00001220| 20 65 72 72 6f 72 0d 0a | 20 20 20 20 65 6e 64 0d | error..|    end.|
|00001230| 0a 20 20 65 6e 64 0d 0a | 18 27 00 00 00 00 00 00 |.  end..|.'......|
|00001240| 00 00 00 00 05 00 00 00 | 14 00 43 48 49 4c 44 20 |........|..CHILD |
|00001250| 49 4e 53 45 52 54 20 43 | 41 53 43 41 44 45 48 02 |INSERT C|ASCADEH.|
|00001260| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |  /* ERw|in Built|
|00001270| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00001280| 0a 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 |.  /* %P|arent %V|
|00001290| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|000012a0| 20 4f 4e 20 43 48 49 4c | 44 20 49 4e 53 45 52 54 | ON CHIL|D INSERT|
|000012b0| 20 43 41 53 43 41 44 45 | 20 2a 2f 0d 0a 20 20 69 | CASCADE| */..  i|
|000012c0| 66 0d 0a 20 20 20 20 2f | 2a 20 25 25 43 68 69 6c |f..    /|* %%Chil|
|000012d0| 64 46 4b 28 22 20 6f 72 | 22 2c 75 70 64 61 74 65 |dFK(" or|",update|
|000012e0| 29 20 2a 2f 0d 0a 20 20 | 20 20 25 43 68 69 6c 64 |) */..  |  %Child|
|000012f0| 46 4b 28 22 20 6f 72 22 | 2c 75 70 64 61 74 65 29 |FK(" or"|,update)|
|00001300| 0d 0a 20 20 62 65 67 69 | 6e 0d 0a 20 20 20 20 69 |..  begi|n..    i|
|00001310| 6e 73 65 72 74 20 25 50 | 61 72 65 6e 74 20 28 25 |nsert %P|arent (%|
|00001320| 50 61 72 65 6e 74 50 4b | 28 22 2c 22 2c 29 29 0d |ParentPK|(",",)).|
|00001330| 0a 20 20 20 20 20 20 73 | 65 6c 65 63 74 20 25 43 |.      s|elect %C|
|00001340| 68 69 6c 64 46 4b 28 22 | 2c 22 2c 29 0d 0a 20 20 |hildFK("|,",)..  |
|00001350| 20 20 20 20 66 72 6f 6d | 20 20 20 69 6e 73 65 72 |    from|   inser|
|00001360| 74 65 64 0d 0a 20 20 20 | 20 20 20 77 68 65 72 65 |ted..   |   where|
|00001370| 0d 0a 20 20 20 20 20 20 | 20 20 2f 2a 20 25 25 4e |..      |  /* %%N|
|00001380| 6f 74 6e 75 6c 6c 46 4b | 28 69 6e 73 65 72 74 65 |otnullFK|(inserte|
|00001390| 64 2c 22 20 69 73 20 6e | 6f 74 20 6e 75 6c 6c 20 |d," is n|ot null |
|000013a0| 61 6e 64 22 29 20 2a 2f | 0d 0a 20 20 20 20 20 20 |and") */|..      |
|000013b0| 20 20 25 4e 6f 74 6e 75 | 6c 6c 46 4b 28 69 6e 73 |  %Notnu|llFK(ins|
|000013c0| 65 72 74 65 64 2c 22 20 | 69 73 20 6e 6f 74 20 6e |erted," |is not n|
|000013d0| 75 6c 6c 20 61 6e 64 22 | 29 0d 0a 20 20 20 20 20 |ull and"|)..     |
|000013e0| 20 20 20 6e 6f 74 20 65 | 78 69 73 74 73 20 28 0d |   not e|xists (.|
|000013f0| 0a 20 20 20 20 20 20 20 | 20 20 20 73 65 6c 65 63 |.       |   selec|
|00001400| 74 20 2a 20 66 72 6f 6d | 20 25 50 61 72 65 6e 74 |t * from| %Parent|
|00001410| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 77 68 65 72 |..      |    wher|
|00001420| 65 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 2f |e..     |       /|
|00001430| 2a 20 25 25 4a 6f 69 6e | 46 4b 50 4b 28 69 6e 73 |* %%Join|FKPK(ins|
|00001440| 65 72 74 65 64 2c 25 50 | 61 72 65 6e 74 2c 22 20 |erted,%P|arent," |
|00001450| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|00001460| 20 20 20 20 20 20 20 20 | 20 20 20 20 25 4a 6f 69 |        |    %Joi|
|00001470| 6e 46 4b 50 4b 28 69 6e | 73 65 72 74 65 64 2c 25 |nFKPK(in|serted,%|
|00001480| 50 61 72 65 6e 74 2c 22 | 20 3d 20 22 2c 22 20 61 |Parent,"| = "," a|
|00001490| 6e 64 22 29 0d 0a 20 20 | 20 20 20 20 20 20 29 0d |nd")..  |      ).|
|000014a0| 0a 20 20 65 6e 64 0d 0a | 19 27 00 00 00 00 00 00 |.  end..|.'......|
|000014b0| 00 00 00 00 05 00 00 00 | 14 00 43 48 49 4c 44 20 |........|..CHILD |
|000014c0| 49 4e 53 45 52 54 20 53 | 45 54 4e 55 4c 4c 6e 02 |INSERT S|ETNULLn.|
|000014d0| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |  /* ERw|in Built|
|000014e0| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|000014f0| 0a 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 |.  /* %P|arent %V|
|00001500| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00001510| 20 4f 4e 20 43 48 49 4c | 44 20 49 4e 53 45 52 54 | ON CHIL|D INSERT|
|00001520| 20 53 45 54 20 4e 55 4c | 4c 20 2a 2f 0d 0a 20 20 | SET NUL|L */..  |
|00001530| 69 66 0d 0a 20 20 20 20 | 2f 2a 20 25 25 43 68 69 |if..    |/* %%Chi|
|00001540| 6c 64 46 4b 28 22 20 6f | 72 22 2c 75 70 64 61 74 |ldFK(" o|r",updat|
|00001550| 65 29 20 2a 2f 0d 0a 20 | 20 20 20 25 43 68 69 6c |e) */.. |   %Chil|
|00001560| 64 46 4b 28 22 20 6f 72 | 22 2c 75 70 64 61 74 65 |dFK(" or|",update|
|00001570| 29 0d 0a 20 20 62 65 67 | 69 6e 0d 0a 20 20 20 20 |)..  beg|in..    |
|00001580| 75 70 64 61 74 65 20 25 | 43 68 69 6c 64 0d 0a 20 |update %|Child.. |
|00001590| 20 20 20 20 20 73 65 74 | 0d 0a 20 20 20 20 20 20 |     set|..      |
|000015a0| 20 20 2f 2a 20 25 25 53 | 65 74 46 4b 28 25 43 68 |  /* %%S|etFK(%Ch|
|000015b0| 69 6c 64 2c 4e 55 4c 4c | 29 20 2a 2f 0d 0a 20 20 |ild,NULL|) */..  |
|000015c0| 20 20 20 20 20 20 25 53 | 65 74 46 4b 28 25 43 68 |      %S|etFK(%Ch|
|000015d0| 69 6c 64 2c 4e 55 4c 4c | 29 0d 0a 20 20 20 20 20 |ild,NULL|)..     |
|000015e0| 20 66 72 6f 6d 20 25 43 | 68 69 6c 64 2c 69 6e 73 | from %C|hild,ins|
|000015f0| 65 72 74 65 64 0d 0a 20 | 20 20 20 20 20 77 68 65 |erted.. |     whe|
|00001600| 72 65 0d 0a 20 20 20 20 | 20 20 20 20 2f 2a 20 25 |re..    |    /* %|
|00001610| 25 4a 6f 69 6e 50 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinPKP|K(%Child|
|00001620| 2c 69 6e 73 65 72 74 65 | 64 2c 22 20 3d 20 22 2c |,inserte|d," = ",|
|00001630| 22 20 61 6e 64 22 29 20 | 2a 2f 0d 0a 20 20 20 20 |" and") |*/..    |
|00001640| 20 20 20 20 25 4a 6f 69 | 6e 50 4b 50 4b 28 25 43 |    %Joi|nPKPK(%C|
|00001650| 68 69 6c 64 2c 69 6e 73 | 65 72 74 65 64 2c 22 20 |hild,ins|erted," |
|00001660| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 61 6e 64 0d |= "," an|d") and.|
|00001670| 0a 20 20 20 20 20 20 20 | 20 6e 6f 74 20 65 78 69 |.       | not exi|
|00001680| 73 74 73 20 28 0d 0a 20 | 20 20 20 20 20 20 20 20 |sts (.. |        |
|00001690| 20 73 65 6c 65 63 74 20 | 2a 20 66 72 6f 6d 20 25 | select |* from %|
|000016a0| 50 61 72 65 6e 74 0d 0a | 20 20 20 20 20 20 20 20 |Parent..|        |
|000016b0| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 |  where.|.       |
|000016c0| 20 20 20 20 20 2f 2a 20 | 25 25 4a 6f 69 6e 46 4b |     /* |%%JoinFK|
|000016d0| 50 4b 28 69 6e 73 65 72 | 74 65 64 2c 25 50 61 72 |PK(inser|ted,%Par|
|000016e0| 65 6e 74 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ent," = |"," and"|
|000016f0| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |) */..  |        |
|00001700| 20 20 25 4a 6f 69 6e 46 | 4b 50 4b 28 69 6e 73 65 |  %JoinF|KPK(inse|
|00001710| 72 74 65 64 2c 25 50 61 | 72 65 6e 74 2c 22 20 3d |rted,%Pa|rent," =|
|00001720| 20 22 2c 22 20 61 6e 64 | 22 29 0d 0a 20 20 20 20 | "," and|")..    |
|00001730| 20 20 20 20 29 0d 0a 20 | 20 65 6e 64 0d 0a 1a 27 |    ).. | end...'|
|00001740| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 15 00 |........|........|
|00001750| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 52 45 53 |CHILD UP|DATE RES|
|00001760| 54 52 49 43 54 f0 02 20 | 20 2f 2a 20 45 52 77 69 |TRICT.. | /* ERwi|
|00001770| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00001780| 69 6d 65 20 2a 2f 0d 0a | 20 20 2f 2a 20 25 50 61 |ime */..|  /* %Pa|
|00001790| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|000017a0| 20 25 43 68 69 6c 64 20 | 4f 4e 20 43 48 49 4c 44 | %Child |ON CHILD|
|000017b0| 20 55 50 44 41 54 45 20 | 52 45 53 54 52 49 43 54 | UPDATE |RESTRICT|
|000017c0| 20 2a 2f 0d 0a 20 20 69 | 66 0d 0a 20 20 20 20 2f | */..  i|f..    /|
|000017d0| 2a 20 25 25 43 68 69 6c | 64 46 4b 28 22 20 6f 72 |* %%Chil|dFK(" or|
|000017e0| 22 2c 75 70 64 61 74 65 | 29 20 2a 2f 0d 0a 20 20 |",update|) */..  |
|000017f0| 20 20 25 43 68 69 6c 64 | 46 4b 28 22 20 6f 72 22 |  %Child|FK(" or"|
|00001800| 2c 75 70 64 61 74 65 29 | 0d 0a 20 20 62 65 67 69 |,update)|..  begi|
|00001810| 6e 0d 0a 20 20 20 20 73 | 65 6c 65 63 74 20 40 6e |n..    s|elect @n|
|00001820| 75 6c 6c 63 6e 74 20 3d | 20 30 0d 0a 20 20 20 20 |ullcnt =| 0..    |
|00001830| 73 65 6c 65 63 74 20 40 | 76 61 6c 69 64 63 6e 74 |select @|validcnt|
|00001840| 20 3d 20 63 6f 75 6e 74 | 28 2a 29 0d 0a 20 20 20 | = count|(*)..   |
|00001850| 20 20 20 66 72 6f 6d 20 | 69 6e 73 65 72 74 65 64 |   from |inserted|
|00001860| 2c 25 50 61 72 65 6e 74 | 0d 0a 20 20 20 20 20 20 |,%Parent|..      |
|00001870| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 |  where.|.       |
|00001880| 20 20 20 2f 2a 20 25 25 | 4a 6f 69 6e 46 4b 50 4b |   /* %%|JoinFKPK|
|00001890| 28 69 6e 73 65 72 74 65 | 64 2c 25 50 61 72 65 6e |(inserte|d,%Paren|
|000018a0| 74 29 20 2a 2f 0d 0a 20 | 20 20 20 20 20 20 20 20 |t) */.. |        |
|000018b0| 20 25 4a 6f 69 6e 46 4b | 50 4b 28 69 6e 73 65 72 | %JoinFK|PK(inser|
|000018c0| 74 65 64 2c 25 50 61 72 | 65 6e 74 29 0d 0a 20 20 |ted,%Par|ent)..  |
|000018d0| 20 20 2f 2a 20 25 25 4e | 6f 74 6e 75 6c 6c 46 4b |  /* %%N|otnullFK|
|000018e0| 28 69 6e 73 65 72 74 65 | 64 2c 22 20 69 73 20 6e |(inserte|d," is n|
|000018f0| 75 6c 6c 22 2c 22 73 65 | 6c 65 63 74 20 40 6e 75 |ull","se|lect @nu|
|00001900| 6c 6c 63 6e 74 20 3d 20 | 63 6f 75 6e 74 28 2a 29 |llcnt = |count(*)|
|00001910| 20 66 72 6f 6d 20 69 6e | 73 65 72 74 65 64 20 77 | from in|serted w|
|00001920| 68 65 72 65 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |here"," |and") */|
|00001930| 0d 0a 20 20 20 20 25 4e | 6f 74 6e 75 6c 6c 46 4b |..    %N|otnullFK|
|00001940| 28 69 6e 73 65 72 74 65 | 64 2c 22 20 69 73 20 6e |(inserte|d," is n|
|00001950| 75 6c 6c 22 2c 22 73 65 | 6c 65 63 74 20 40 6e 75 |ull","se|lect @nu|
|00001960| 6c 6c 63 6e 74 20 3d 20 | 63 6f 75 6e 74 28 2a 29 |llcnt = |count(*)|
|00001970| 20 66 72 6f 6d 20 69 6e | 73 65 72 74 65 64 20 77 | from in|serted w|
|00001980| 68 65 72 65 22 2c 22 20 | 61 6e 64 22 29 0d 0a 20 |here"," |and").. |
|00001990| 20 20 20 69 66 20 40 76 | 61 6c 69 64 63 6e 74 20 |   if @v|alidcnt |
|000019a0| 2b 20 40 6e 75 6c 6c 63 | 6e 74 20 21 3d 20 40 6e |+ @nullc|nt != @n|
|000019b0| 75 6d 72 6f 77 73 0d 0a | 20 20 20 20 62 65 67 69 |umrows..|    begi|
|000019c0| 6e 0d 0a 20 20 20 20 20 | 20 73 65 6c 65 63 74 20 |n..     | select |
|000019d0| 40 65 72 72 6e 6f 20 20 | 3d 20 33 30 30 30 37 2c |@errno  |= 30007,|
|000019e0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 40 |..      |       @|
|000019f0| 65 72 72 6d 73 67 20 3d | 20 27 43 61 6e 6e 6f 74 |errmsg =| 'Cannot|
|00001a00| 20 55 50 44 41 54 45 20 | 22 25 43 68 69 6c 64 22 | UPDATE |"%Child"|
|00001a10| 20 62 65 63 61 75 73 65 | 20 22 25 50 61 72 65 6e | because| "%Paren|
|00001a20| 74 22 20 64 6f 65 73 20 | 6e 6f 74 20 65 78 69 73 |t" does |not exis|
|00001a30| 74 2e 27 0d 0a 20 20 20 | 20 20 20 67 6f 74 6f 20 |t.'..   |   goto |
|00001a40| 65 72 72 6f 72 0d 0a 20 | 20 20 20 65 6e 64 0d 0a |error.. |   end..|
|00001a50| 20 20 65 6e 64 0d 0a 1c | 27 00 00 00 00 00 00 00 |  end...|'.......|
|00001a60| 00 00 00 05 00 00 00 14 | 00 43 48 49 4c 44 20 55 |........|.CHILD U|
|00001a70| 50 44 41 54 45 20 43 41 | 53 43 41 44 45 48 02 20 |PDATE CA|SCADEH. |
|00001a80| 20 2f 2a 20 45 52 77 69 | 6e 20 42 75 69 6c 74 69 | /* ERwi|n Builti|
|00001a90| 6e 20 25 44 61 74 65 74 | 69 6d 65 20 2a 2f 0d 0a |n %Datet|ime */..|
|00001aa0| 20 20 2f 2a 20 25 50 61 | 72 65 6e 74 20 25 56 65 |  /* %Pa|rent %Ve|
|00001ab0| 72 62 50 68 72 61 73 65 | 20 25 43 68 69 6c 64 20 |rbPhrase| %Child |
|00001ac0| 4f 4e 20 43 48 49 4c 44 | 20 55 50 44 41 54 45 20 |ON CHILD| UPDATE |
|00001ad0| 43 41 53 43 41 44 45 20 | 2a 2f 0d 0a 20 20 69 66 |CASCADE |*/..  if|
|00001ae0| 0d 0a 20 20 20 20 2f 2a | 20 25 25 43 68 69 6c 64 |..    /*| %%Child|
|00001af0| 46 4b 28 22 20 6f 72 22 | 2c 75 70 64 61 74 65 29 |FK(" or"|,update)|
|00001b00| 20 2a 2f 0d 0a 20 20 20 | 20 25 43 68 69 6c 64 46 | */..   | %ChildF|
|00001b10| 4b 28 22 20 6f 72 22 2c | 75 70 64 61 74 65 29 0d |K(" or",|update).|
|00001b20| 0a 20 20 62 65 67 69 6e | 0d 0a 20 20 20 20 69 6e |.  begin|..    in|
|00001b30| 73 65 72 74 20 25 50 61 | 72 65 6e 74 20 28 25 50 |sert %Pa|rent (%P|
|00001b40| 61 72 65 6e 74 50 4b 28 | 22 2c 22 2c 29 29 0d 0a |arentPK(|",",))..|
|00001b50| 20 20 20 20 20 20 73 65 | 6c 65 63 74 20 25 43 68 |      se|lect %Ch|
|00001b60| 69 6c 64 46 4b 28 22 2c | 22 2c 29 0d 0a 20 20 20 |ildFK(",|",)..   |
|00001b70| 20 20 20 66 72 6f 6d 20 | 20 20 69 6e 73 65 72 74 |   from |  insert|
|00001b80| 65 64 0d 0a 20 20 20 20 | 20 20 77 68 65 72 65 0d |ed..    |  where.|
|00001b90| 0a 20 20 20 20 20 20 20 | 20 2f 2a 20 25 25 4e 6f |.       | /* %%No|
|00001ba0| 74 6e 75 6c 6c 46 4b 28 | 69 6e 73 65 72 74 65 64 |tnullFK(|inserted|
|00001bb0| 2c 22 20 69 73 20 6e 6f | 74 20 6e 75 6c 6c 20 61 |," is no|t null a|
|00001bc0| 6e 64 22 29 20 2a 2f 0d | 0a 20 20 20 20 20 20 20 |nd") */.|.       |
|00001bd0| 20 25 4e 6f 74 6e 75 6c | 6c 46 4b 28 69 6e 73 65 | %Notnul|lFK(inse|
|00001be0| 72 74 65 64 2c 22 20 69 | 73 20 6e 6f 74 20 6e 75 |rted," i|s not nu|
|00001bf0| 6c 6c 20 61 6e 64 22 29 | 0d 0a 20 20 20 20 20 20 |ll and")|..      |
|00001c00| 20 20 6e 6f 74 20 65 78 | 69 73 74 73 20 28 0d 0a |  not ex|ists (..|
|00001c10| 20 20 20 20 20 20 20 20 | 20 20 73 65 6c 65 63 74 |        |  select|
|00001c20| 20 2a 20 66 72 6f 6d 20 | 25 50 61 72 65 6e 74 0d | * from |%Parent.|
|00001c30| 0a 20 20 20 20 20 20 20 | 20 20 20 77 68 65 72 65 |.       |   where|
|00001c40| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 2f 2a |..      |      /*|
|00001c50| 20 25 25 4a 6f 69 6e 46 | 4b 50 4b 28 69 6e 73 65 | %%JoinF|KPK(inse|
|00001c60| 72 74 65 64 2c 25 50 61 | 72 65 6e 74 2c 22 20 3d |rted,%Pa|rent," =|
|00001c70| 20 22 2c 22 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 | "," and|") */.. |
|00001c80| 20 20 20 20 20 20 20 20 | 20 20 20 25 4a 6f 69 6e |        |   %Join|
|00001c90| 46 4b 50 4b 28 69 6e 73 | 65 72 74 65 64 2c 25 50 |FKPK(ins|erted,%P|
|00001ca0| 61 72 65 6e 74 2c 22 20 | 3d 20 22 2c 22 20 61 6e |arent," |= "," an|
|00001cb0| 64 22 29 0d 0a 20 20 20 | 20 20 20 20 20 29 0d 0a |d")..   |     )..|
|00001cc0| 20 20 65 6e 64 0d 0a 1d | 27 00 00 00 00 00 00 00 |  end...|'.......|
|00001cd0| 00 00 00 05 00 00 00 14 | 00 43 48 49 4c 44 20 55 |........|.CHILD U|
|00001ce0| 50 44 41 54 45 20 53 45 | 54 4e 55 4c 4c 6f 02 20 |PDATE SE|TNULLo. |
|00001cf0| 20 2f 2a 20 45 52 77 69 | 6e 20 42 75 69 6c 74 69 | /* ERwi|n Builti|
|00001d00| 6e 20 25 44 61 74 65 74 | 69 6d 65 20 2a 2f 0d 0a |n %Datet|ime */..|
|00001d10| 20 20 2f 2a 20 25 50 61 | 72 65 6e 74 20 25 56 65 |  /* %Pa|rent %Ve|
|00001d20| 72 62 50 68 72 61 73 65 | 20 25 43 68 69 6c 64 20 |rbPhrase| %Child |
|00001d30| 4f 4e 20 43 48 49 4c 44 | 20 55 50 44 41 54 45 20 |ON CHILD| UPDATE |
|00001d40| 53 45 54 20 4e 55 4c 4c | 20 2a 2f 0d 0a 20 20 69 |SET NULL| */..  i|
|00001d50| 66 0d 0a 20 20 20 20 2f | 2a 20 25 25 43 68 69 6c |f..    /|* %%Chil|
|00001d60| 64 46 4b 28 22 20 6f 72 | 22 2c 75 70 64 61 74 65 |dFK(" or|",update|
|00001d70| 29 20 2a 2f 0d 0a 20 20 | 20 20 25 43 68 69 6c 64 |) */..  |  %Child|
|00001d80| 46 4b 28 22 20 6f 72 22 | 2c 75 70 64 61 74 65 29 |FK(" or"|,update)|
|00001d90| 0d 0a 20 20 62 65 67 69 | 6e 0d 0a 20 20 20 20 75 |..  begi|n..    u|
|00001da0| 70 64 61 74 65 20 25 43 | 68 69 6c 64 0d 0a 20 20 |pdate %C|hild..  |
|00001db0| 20 20 20 20 73 65 74 0d | 0a 20 20 20 20 20 20 20 |    set.|.       |
|00001dc0| 20 2f 2a 20 25 25 53 65 | 74 46 4b 28 25 43 68 69 | /* %%Se|tFK(%Chi|
|00001dd0| 6c 64 2c 4e 55 4c 4c 29 | 20 2a 2f 0d 0a 20 20 20 |ld,NULL)| */..   |
|00001de0| 20 20 20 20 20 25 53 65 | 74 46 4b 28 25 43 68 69 |     %Se|tFK(%Chi|
|00001df0| 6c 64 2c 4e 55 4c 4c 29 | 0d 0a 20 20 20 20 20 20 |ld,NULL)|..      |
|00001e00| 66 72 6f 6d 20 25 43 68 | 69 6c 64 2c 69 6e 73 65 |from %Ch|ild,inse|
|00001e10| 72 74 65 64 0d 0a 20 20 | 20 20 20 20 77 68 65 72 |rted..  |    wher|
|00001e20| 65 0d 0a 20 20 20 20 20 | 20 20 20 2f 2a 20 25 25 |e..     |   /* %%|
|00001e30| 4a 6f 69 6e 50 4b 50 4b | 28 25 43 68 69 6c 64 2c |JoinPKPK|(%Child,|
|00001e40| 69 6e 73 65 72 74 65 64 | 2c 22 20 3d 20 22 2c 22 |inserted|," = ","|
|00001e50| 20 61 6e 64 22 29 20 2a | 2f 0d 0a 20 20 20 20 20 | and") *|/..     |
|00001e60| 20 20 20 25 4a 6f 69 6e | 50 4b 50 4b 28 25 43 68 |   %Join|PKPK(%Ch|
|00001e70| 69 6c 64 2c 69 6e 73 65 | 72 74 65 64 2c 22 20 3d |ild,inse|rted," =|
|00001e80| 20 22 2c 22 20 61 6e 64 | 22 29 20 61 6e 64 20 0d | "," and|") and .|
|00001e90| 0a 20 20 20 20 20 20 20 | 20 6e 6f 74 20 65 78 69 |.       | not exi|
|00001ea0| 73 74 73 20 28 0d 0a 20 | 20 20 20 20 20 20 20 20 |sts (.. |        |
|00001eb0| 20 73 65 6c 65 63 74 20 | 2a 20 66 72 6f 6d 20 25 | select |* from %|
|00001ec0| 50 61 72 65 6e 74 0d 0a | 20 20 20 20 20 20 20 20 |Parent..|        |
|00001ed0| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 |  where.|.       |
|00001ee0| 20 20 20 20 20 2f 2a 20 | 25 25 4a 6f 69 6e 46 4b |     /* |%%JoinFK|
|00001ef0| 50 4b 28 69 6e 73 65 72 | 74 65 64 2c 25 50 61 72 |PK(inser|ted,%Par|
|00001f00| 65 6e 74 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ent," = |"," and"|
|00001f10| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |) */..  |        |
|00001f20| 20 20 25 4a 6f 69 6e 46 | 4b 50 4b 28 69 6e 73 65 |  %JoinF|KPK(inse|
|00001f30| 72 74 65 64 2c 25 50 61 | 72 65 6e 74 2c 22 20 3d |rted,%Pa|rent," =|
|00001f40| 20 22 2c 22 20 61 6e 64 | 22 29 0d 0a 20 20 20 20 | "," and|")..    |
|00001f50| 20 20 20 20 29 0d 0a 20 | 20 65 6e 64 0d 0a 1e 27 |    ).. | end...'|
|00001f60| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 15 00 |........|........|
|00001f70| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 52 45 53 |CHILD DE|LETE RES|
|00001f80| 54 52 49 43 54 67 02 20 | 20 20 20 2f 2a 20 45 52 |TRICTg. |   /* ER|
|00001f90| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|00001fa0| 65 74 69 6d 65 20 2a 2f | 0d 0a 20 20 20 20 2f 2a |etime */|..    /*|
|00001fb0| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00001fc0| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 43 |rase %Ch|ild ON C|
|00001fd0| 48 49 4c 44 20 44 45 4c | 45 54 45 20 52 45 53 54 |HILD DEL|ETE REST|
|00001fe0| 52 49 43 54 20 2a 2f 0d | 0a 20 20 20 20 69 66 20 |RICT */.|.    if |
|00001ff0| 65 78 69 73 74 73 20 28 | 73 65 6c 65 63 74 20 2a |exists (|select *|
|00002000| 20 66 72 6f 6d 20 64 65 | 6c 65 74 65 64 2c 25 50 | from de|leted,%P|
|00002010| 61 72 65 6e 74 0d 0a 20 | 20 20 20 20 20 77 68 65 |arent.. |     whe|
|00002020| 72 65 0d 0a 20 20 20 20 | 20 20 20 20 2f 2a 20 25 |re..    |    /* %|
|00002030| 25 4a 6f 69 6e 46 4b 50 | 4b 28 64 65 6c 65 74 65 |%JoinFKP|K(delete|
|00002040| 64 2c 25 50 61 72 65 6e | 74 2c 22 20 3d 20 22 2c |d,%Paren|t," = ",|
|00002050| 22 20 61 6e 64 22 29 20 | 2a 2f 0d 0a 20 20 20 20 |" and") |*/..    |
|00002060| 20 20 20 20 25 4a 6f 69 | 6e 46 4b 50 4b 28 64 65 |    %Joi|nFKPK(de|
|00002070| 6c 65 74 65 64 2c 25 50 | 61 72 65 6e 74 2c 22 20 |leted,%P|arent," |
|00002080| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 61 6e 64 0d |= "," an|d") and.|
|00002090| 0a 20 20 20 20 20 20 20 | 20 6e 6f 74 20 65 78 69 |.       | not exi|
|000020a0| 73 74 73 20 28 0d 0a 20 | 20 20 20 20 20 20 20 20 |sts (.. |        |
|000020b0| 20 73 65 6c 65 63 74 20 | 2a 20 66 72 6f 6d 20 25 | select |* from %|
|000020c0| 43 68 69 6c 64 0d 0a 20 | 20 20 20 20 20 20 20 20 |Child.. |        |
|000020d0| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|000020e0| 20 20 20 20 2f 2a 20 25 | 25 4a 6f 69 6e 46 4b 50 |    /* %|%JoinFKP|
|000020f0| 4b 28 25 43 68 69 6c 64 | 2c 25 50 61 72 65 6e 74 |K(%Child|,%Parent|
|00002100| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 20 2a |," = ","| and") *|
|00002110| 2f 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 25 |/..     |       %|
|00002120| 4a 6f 69 6e 46 4b 50 4b | 28 25 43 68 69 6c 64 2c |JoinFKPK|(%Child,|
|00002130| 25 50 61 72 65 6e 74 2c | 22 20 3d 20 22 2c 22 20 |%Parent,|" = "," |
|00002140| 61 6e 64 22 29 0d 0a 20 | 20 20 20 20 20 20 20 29 |and").. |       )|
|00002150| 0d 0a 20 20 20 20 29 0d | 0a 20 20 20 20 62 65 67 |..    ).|.    beg|
|00002160| 69 6e 0d 0a 20 20 20 20 | 20 20 73 65 6c 65 63 74 |in..    |  select|
|00002170| 20 40 65 72 72 6e 6f 20 | 20 3d 20 33 30 30 31 30 | @errno | = 30010|
|00002180| 2c 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,..     |        |
|00002190| 40 65 72 72 6d 73 67 20 | 3d 20 27 43 61 6e 6e 6f |@errmsg |= 'Canno|
|000021a0| 74 20 44 45 4c 45 54 45 | 20 6c 61 73 74 20 22 25 |t DELETE| last "%|
|000021b0| 43 68 69 6c 64 22 20 62 | 65 63 61 75 73 65 20 22 |Child" b|ecause "|
|000021c0| 25 50 61 72 65 6e 74 22 | 20 65 78 69 73 74 73 2e |%Parent"| exists.|
|000021d0| 27 0d 0a 20 20 20 20 20 | 20 67 6f 74 6f 20 65 72 |'..     | goto er|
|000021e0| 72 6f 72 0d 0a 20 20 20 | 20 65 6e 64 0d 0a 20 27 |ror..   | end.. '|
|000021f0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 14 00 |........|........|
|00002200| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 43 41 53 |CHILD DE|LETE CAS|
|00002210| 43 41 44 45 cc 01 20 20 | 20 20 2f 2a 20 45 52 77 |CADE..  |  /* ERw|
|00002220| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00002230| 74 69 6d 65 20 2a 2f 0d | 0a 20 20 20 20 2f 2a 20 |time */.|.    /* |
|00002240| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|00002250| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 43 48 |ase %Chi|ld ON CH|
|00002260| 49 4c 44 20 44 45 4c 45 | 54 45 20 43 41 53 43 41 |ILD DELE|TE CASCA|
|00002270| 44 45 20 2a 2f 0d 0a 20 | 20 20 20 64 65 6c 65 74 |DE */.. |   delet|
|00002280| 65 20 25 50 61 72 65 6e | 74 0d 0a 20 20 20 20 20 |e %Paren|t..     |
|00002290| 20 66 72 6f 6d 20 25 50 | 61 72 65 6e 74 2c 64 65 | from %P|arent,de|
|000022a0| 6c 65 74 65 64 0d 0a 20 | 20 20 20 20 20 77 68 65 |leted.. |     whe|
|000022b0| 72 65 0d 0a 20 20 20 20 | 20 20 20 20 2f 2a 20 25 |re..    |    /* %|
|000022c0| 25 4a 6f 69 6e 46 4b 50 | 4b 28 64 65 6c 65 74 65 |%JoinFKP|K(delete|
|000022d0| 64 2c 25 50 61 72 65 6e | 74 2c 22 20 3d 20 22 2c |d,%Paren|t," = ",|
|000022e0| 22 20 61 6e 64 22 29 20 | 2a 2f 0d 0a 20 20 20 20 |" and") |*/..    |
|000022f0| 20 20 20 20 25 4a 6f 69 | 6e 46 4b 50 4b 28 64 65 |    %Joi|nFKPK(de|
|00002300| 6c 65 74 65 64 2c 25 50 | 61 72 65 6e 74 2c 22 20 |leted,%P|arent," |
|00002310| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 61 6e 64 0d |= "," an|d") and.|
|00002320| 0a 20 20 20 20 20 20 20 | 20 6e 6f 74 20 65 78 69 |.       | not exi|
|00002330| 73 74 73 20 28 0d 0a 20 | 20 20 20 20 20 20 20 20 |sts (.. |        |
|00002340| 20 73 65 6c 65 63 74 20 | 2a 20 66 72 6f 6d 20 25 | select |* from %|
|00002350| 43 68 69 6c 64 0d 0a 20 | 20 20 20 20 20 20 20 20 |Child.. |        |
|00002360| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|00002370| 20 20 20 20 2f 2a 20 25 | 25 4a 6f 69 6e 46 4b 50 |    /* %|%JoinFKP|
|00002380| 4b 28 25 43 68 69 6c 64 | 2c 25 50 61 72 65 6e 74 |K(%Child|,%Parent|
|00002390| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 20 2a |," = ","| and") *|
|000023a0| 2f 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 25 |/..     |       %|
|000023b0| 4a 6f 69 6e 46 4b 50 4b | 28 25 43 68 69 6c 64 2c |JoinFKPK|(%Child,|
|000023c0| 25 50 61 72 65 6e 74 2c | 22 20 3d 20 22 2c 22 20 |%Parent,|" = "," |
|000023d0| 61 6e 64 22 29 0d 0a 20 | 20 20 20 20 20 20 20 29 |and").. |       )|
|000023e0| 0d 0a 21 27 00 00 00 00 | 00 00 00 00 00 00 05 00 |..!'....|........|
|000023f0| 00 00 16 00 50 41 52 45 | 4e 54 20 49 4e 53 45 52 |....PARE|NT INSER|
|00002400| 54 20 52 45 53 54 52 49 | 43 54 e8 01 20 20 20 20 |T RESTRI|CT..    |
|00002410| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00002420| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00002430| 20 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 |   /* %P|arent %V|
|00002440| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00002450| 20 4f 4e 20 50 41 52 45 | 4e 54 20 49 4e 53 45 52 | ON PARE|NT INSER|
|00002460| 54 20 52 45 53 54 52 49 | 43 54 20 2a 2f 0d 0a 20 |T RESTRI|CT */.. |
|00002470| 20 20 20 69 66 20 65 78 | 69 73 74 73 20 28 73 65 |   if ex|ists (se|
|00002480| 6c 65 63 74 20 2a 20 66 | 72 6f 6d 20 69 6e 73 65 |lect * f|rom inse|
|00002490| 72 74 65 64 0d 0a 20 20 | 20 20 20 20 77 68 65 72 |rted..  |    wher|
|000024a0| 65 20 6e 6f 74 20 65 78 | 69 73 74 73 20 28 0d 0a |e not ex|ists (..|
|000024b0| 20 20 20 20 20 20 20 20 | 20 20 73 65 6c 65 63 74 |        |  select|
|000024c0| 20 2a 20 66 72 6f 6d 20 | 25 43 68 69 6c 64 0d 0a | * from |%Child..|
|000024d0| 20 20 20 20 20 20 20 20 | 20 20 77 68 65 72 65 0d |        |  where.|
|000024e0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 2f 2a 20 |.       |     /* |
|000024f0| 25 25 4a 6f 69 6e 46 4b | 50 4b 28 25 43 68 69 6c |%%JoinFK|PK(%Chil|
|00002500| 64 2c 69 6e 73 65 72 74 | 65 64 2c 22 20 3d 20 22 |d,insert|ed," = "|
|00002510| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */..   |
|00002520| 20 20 20 20 20 20 20 20 | 20 25 4a 6f 69 6e 46 4b |        | %JoinFK|
|00002530| 50 4b 28 25 43 68 69 6c | 64 2c 69 6e 73 65 72 74 |PK(%Chil|d,insert|
|00002540| 65 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ed," = "|," and")|
|00002550| 0d 0a 20 20 20 20 20 20 | 29 0d 0a 20 20 20 20 29 |..      |)..    )|
|00002560| 0d 0a 20 20 20 20 62 65 | 67 69 6e 0d 0a 20 20 20 |..    be|gin..   |
|00002570| 20 20 20 73 65 6c 65 63 | 74 20 40 65 72 72 6e 6f |   selec|t @errno|
|00002580| 20 20 3d 20 33 30 30 31 | 31 2c 0d 0a 20 20 20 20 |  = 3001|1,..    |
|00002590| 20 20 20 20 20 20 20 20 | 20 40 65 72 72 6d 73 67 |        | @errmsg|
|000025a0| 20 3d 20 27 43 61 6e 6e | 6f 74 20 49 4e 53 45 52 | = 'Cann|ot INSER|
|000025b0| 54 20 22 25 50 61 72 65 | 6e 74 22 20 62 65 63 61 |T "%Pare|nt" beca|
|000025c0| 75 73 65 20 22 25 43 68 | 69 6c 64 22 20 64 6f 65 |use "%Ch|ild" doe|
|000025d0| 73 20 6e 6f 74 2e 27 0d | 0a 20 20 20 20 20 20 67 |s not.'.|.      g|
|000025e0| 6f 74 6f 20 65 72 72 6f | 72 0d 0a 20 20 20 20 65 |oto erro|r..    e|
|000025f0| 6e 64 0d 0a 24 27 00 00 | 00 00 00 00 00 00 00 00 |nd..$'..|........|
|00002600| 05 00 00 00 0d 00 55 50 | 44 41 54 45 20 48 45 41 |......UP|DATE HEA|
|00002610| 44 45 52 aa 01 63 72 65 | 61 74 65 20 74 72 69 67 |DER..cre|ate trig|
|00002620| 67 65 72 20 74 25 31 41 | 63 74 69 6f 6e 5f 25 32 |ger t%1A|ction_%2|
|00002630| 37 54 61 62 6c 65 4e 61 | 6d 65 20 6f 6e 20 25 54 |7TableNa|me on %T|
|00002640| 61 62 6c 65 4e 61 6d 65 | 20 66 6f 72 20 25 41 63 |ableName| for %Ac|
|00002650| 74 69 6f 6e 20 61 73 0d | 0a 2f 2a 20 45 52 77 69 |tion as.|./* ERwi|
|00002660| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00002670| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 41 63 74 69 |ime */..|/* %Acti|
|00002680| 6f 6e 20 74 72 69 67 67 | 65 72 20 6f 6e 20 25 54 |on trigg|er on %T|
|00002690| 61 62 6c 65 4e 61 6d 65 | 20 2a 2f 0d 0a 62 65 67 |ableName| */..beg|
|000026a0| 69 6e 0d 0a 20 20 64 65 | 63 6c 61 72 65 20 20 40 |in..  de|clare  @|
|000026b0| 6e 75 6d 72 6f 77 73 20 | 69 6e 74 2c 0d 0a 20 20 |numrows |int,..  |
|000026c0| 20 20 20 20 20 20 20 20 | 20 40 6e 75 6c 6c 63 6e |        | @nullcn|
|000026d0| 74 20 69 6e 74 2c 0d 0a | 20 20 20 20 20 20 20 20 |t int,..|        |
|000026e0| 20 20 20 40 76 61 6c 69 | 64 63 6e 74 20 69 6e 74 |   @vali|dcnt int|
|000026f0| 2c 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 25 50 |,..     |      %P|
|00002700| 4b 44 65 63 6c 28 2c 40 | 69 6e 73 29 25 64 65 63 |KDecl(,@|ins)%dec|
|00002710| 6c 28 62 43 6f 6d 6d 61 | 2c 30 29 25 46 6f 72 45 |l(bComma|,0)%ForE|
|00002720| 61 63 68 41 74 74 28 29 | 20 7b 25 69 66 28 25 41 |achAtt()| {%if(%A|
|00002730| 74 74 49 73 50 6b 29 20 | 7b 25 3d 28 62 43 6f 6d |ttIsPk) |{%=(bCom|
|00002740| 6d 61 2c 31 29 7d 20 7d | 25 69 66 20 28 25 3d 3d |ma,1)} }|%if (%==|
|00002750| 28 25 3a 62 43 6f 6d 6d | 61 2c 31 29 29 20 7b 2c |(%:bComm|a,1)) {,|
|00002760| 7d 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 40 65 |}..     |      @e|
|00002770| 72 72 6e 6f 20 20 20 69 | 6e 74 2c 0d 0a 20 20 20 |rrno   i|nt,..   |
|00002780| 20 20 20 20 20 20 20 20 | 40 65 72 72 6d 73 67 20 |        |@errmsg |
|00002790| 20 76 61 72 63 68 61 72 | 28 32 35 35 29 0d 0a 0d | varchar|(255)...|
|000027a0| 0a 20 20 73 65 6c 65 63 | 74 20 40 6e 75 6d 72 6f |.  selec|t @numro|
|000027b0| 77 73 20 3d 20 40 40 72 | 6f 77 63 6f 75 6e 74 28 |ws = @@r|owcount(|
|000027c0| 27 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 0d |'.......|........|
|000027d0| 00 55 50 44 41 54 45 20 | 46 4f 4f 54 45 52 74 00 |.UPDATE |FOOTERt.|
|000027e0| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |  /* ERw|in Built|
|000027f0| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00002800| 0a 20 20 72 65 74 75 72 | 6e 0d 0a 65 72 72 6f 72 |.  retur|n..error|
|00002810| 3a 0d 0a 20 20 20 20 72 | 61 69 73 65 72 72 6f 72 |:..    r|aiserror|
|00002820| 20 40 65 72 72 6e 6f 20 | 40 65 72 72 6d 73 67 0d | @errno |@errmsg.|
|00002830| 0a 20 20 20 20 72 6f 6c | 6c 62 61 63 6b 20 74 72 |.    rol|lback tr|
|00002840| 61 6e 73 61 63 74 69 6f | 6e 0d 0a 65 6e 64 0d 0a |ansactio|n..end..|
|00002850| 67 6f 0d 0a 29 27 00 00 | 00 00 00 00 00 00 00 00 |go..)'..|........|
|00002860| 05 00 00 00 0d 00 44 45 | 4c 45 54 45 20 48 45 41 |......DE|LETE HEA|
|00002870| 44 45 52 c9 00 63 72 65 | 61 74 65 20 74 72 69 67 |DER..cre|ate trig|
|00002880| 67 65 72 20 74 25 31 41 | 63 74 69 6f 6e 5f 25 32 |ger t%1A|ction_%2|
|00002890| 37 54 61 62 6c 65 4e 61 | 6d 65 20 6f 6e 20 25 54 |7TableNa|me on %T|
|000028a0| 61 62 6c 65 4e 61 6d 65 | 20 66 6f 72 20 25 41 63 |ableName| for %Ac|
|000028b0| 74 69 6f 6e 20 61 73 0d | 0a 2f 2a 20 45 52 77 69 |tion as.|./* ERwi|
|000028c0| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|000028d0| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 41 63 74 69 |ime */..|/* %Acti|
|000028e0| 6f 6e 20 74 72 69 67 67 | 65 72 20 6f 6e 20 25 54 |on trigg|er on %T|
|000028f0| 61 62 6c 65 4e 61 6d 65 | 20 2a 2f 0d 0a 62 65 67 |ableName| */..beg|
|00002900| 69 6e 0d 0a 20 20 64 65 | 63 6c 61 72 65 20 20 40 |in..  de|clare  @|
|00002910| 65 72 72 6e 6f 20 20 20 | 69 6e 74 2c 0d 0a 20 20 |errno   |int,..  |
|00002920| 20 20 20 20 20 20 20 20 | 20 40 65 72 72 6d 73 67 |        | @errmsg|
|00002930| 20 20 76 61 72 63 68 61 | 72 28 32 35 35 29 2a 27 |  varcha|r(255)*'|
|00002940| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 0d 00 |........|........|
|00002950| 44 45 4c 45 54 45 20 46 | 4f 4f 54 45 52 78 00 20 |DELETE F|OOTERx. |
|00002960| 20 20 20 2f 2a 20 45 52 | 77 69 6e 20 42 75 69 6c |   /* ER|win Buil|
|00002970| 74 69 6e 20 25 44 61 74 | 65 74 69 6d 65 20 2a 2f |tin %Dat|etime */|
|00002980| 0d 0a 20 20 20 20 72 65 | 74 75 72 6e 0d 0a 65 72 |..    re|turn..er|
|00002990| 72 6f 72 3a 0d 0a 20 20 | 20 20 72 61 69 73 65 72 |ror:..  |  raiser|
|000029a0| 72 6f 72 20 40 65 72 72 | 6e 6f 20 40 65 72 72 6d |ror @err|no @errm|
|000029b0| 73 67 0d 0a 20 20 20 20 | 72 6f 6c 6c 62 61 63 6b |sg..    |rollback|
|000029c0| 20 74 72 61 6e 73 61 63 | 74 69 6f 6e 0d 0a 65 6e | transac|tion..en|
|000029d0| 64 0d 0a 67 6f 0d 0a 2b | 27 00 00 00 00 00 00 00 |d..go..+|'.......|
|000029e0| 00 00 00 05 00 00 00 0d | 00 49 4e 53 45 52 54 20 |........|.INSERT |
|000029f0| 48 45 41 44 45 52 3a 01 | 63 72 65 61 74 65 20 74 |HEADER:.|create t|
|00002a00| 72 69 67 67 65 72 20 74 | 25 31 41 63 74 69 6f 6e |rigger t|%1Action|
|00002a10| 5f 25 32 37 54 61 62 6c | 65 4e 61 6d 65 20 6f 6e |_%27Tabl|eName on|
|00002a20| 20 25 54 61 62 6c 65 4e | 61 6d 65 20 66 6f 72 20 | %TableN|ame for |
|00002a30| 25 41 63 74 69 6f 6e 20 | 61 73 0d 0a 2f 2a 20 45 |%Action |as../* E|
|00002a40| 52 77 69 6e 20 42 75 69 | 6c 74 69 6e 20 25 44 61 |Rwin Bui|ltin %Da|
|00002a50| 74 65 74 69 6d 65 20 2a | 2f 0d 0a 2f 2a 20 25 41 |tetime *|/../* %A|
|00002a60| 63 74 69 6f 6e 20 74 72 | 69 67 67 65 72 20 6f 6e |ction tr|igger on|
|00002a70| 20 25 54 61 62 6c 65 4e | 61 6d 65 20 2a 2f 0d 0a | %TableN|ame */..|
|00002a80| 62 65 67 69 6e 0d 0a 20 | 20 64 65 63 6c 61 72 65 |begin.. | declare|
|00002a90| 20 20 40 6e 75 6d 72 6f | 77 73 20 69 6e 74 2c 0d |  @numro|ws int,.|
|00002aa0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 40 6e 75 6c |.       |    @nul|
|00002ab0| 6c 63 6e 74 20 69 6e 74 | 2c 0d 0a 20 20 20 20 20 |lcnt int|,..     |
|00002ac0| 20 20 20 20 20 20 40 76 | 61 6c 69 64 63 6e 74 20 |      @v|alidcnt |
|00002ad0| 69 6e 74 2c 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |int,..  |        |
|00002ae0| 20 40 65 72 72 6e 6f 20 | 20 20 69 6e 74 2c 0d 0a | @errno |  int,..|
|00002af0| 20 20 20 20 20 20 20 20 | 20 20 20 40 65 72 72 6d |        |   @errm|
|00002b00| 73 67 20 20 76 61 72 63 | 68 61 72 28 32 35 35 29 |sg  varc|har(255)|
|00002b10| 0d 0a 0d 0a 20 20 73 65 | 6c 65 63 74 20 40 6e 75 |....  se|lect @nu|
|00002b20| 6d 72 6f 77 73 20 3d 20 | 40 40 72 6f 77 63 6f 75 |mrows = |@@rowcou|
|00002b30| 6e 74 2c 27 00 00 00 00 | 00 00 00 00 00 00 05 00 |nt,'....|........|
|00002b40| 00 00 0d 00 49 4e 53 45 | 52 54 20 46 4f 4f 54 45 |....INSE|RT FOOTE|
|00002b50| 52 74 00 20 20 2f 2a 20 | 45 52 77 69 6e 20 42 75 |Rt.  /* |ERwin Bu|
|00002b60| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|00002b70| 2a 2f 0d 0a 20 20 72 65 | 74 75 72 6e 0d 0a 65 72 |*/..  re|turn..er|
|00002b80| 72 6f 72 3a 0d 0a 20 20 | 20 20 72 61 69 73 65 72 |ror:..  |  raiser|
|00002b90| 72 6f 72 20 40 65 72 72 | 6e 6f 20 40 65 72 72 6d |ror @err|no @errm|
|00002ba0| 73 67 0d 0a 20 20 20 20 | 72 6f 6c 6c 62 61 63 6b |sg..    |rollback|
|00002bb0| 20 74 72 61 6e 73 61 63 | 74 69 6f 6e 0d 0a 65 6e | transac|tion..en|
|00002bc0| 64 0d 0a 67 6f 0d 0a 2d | 27 00 00 00 00 00 00 00 |d..go..-|'.......|
|00002bd0| 00 00 00 05 00 00 00 15 | 00 43 55 53 54 4f 4d 20 |........|.CUSTOM |
|00002be0| 54 52 49 47 47 45 52 20 | 48 45 41 44 45 52 46 00 |TRIGGER |HEADERF.|
|00002bf0| 63 72 65 61 74 65 20 74 | 72 69 67 67 65 72 20 25 |create t|rigger %|
|00002c00| 54 72 69 67 67 65 72 4e | 61 6d 65 20 6f 6e 20 25 |TriggerN|ame on %|
|00002c10| 54 61 62 6c 65 4e 61 6d | 65 0d 0a 20 20 66 6f 72 |TableNam|e..  for|
|00002c20| 20 25 41 63 74 69 6f 6e | 73 28 22 2c 22 29 0d 0a | %Action|s(",")..|
|00002c30| 20 20 61 73 0d 0a 2e 27 | 00 00 00 00 00 00 00 00 |  as...'|........|
|00002c40| 00 00 05 00 00 00 15 00 | 43 55 53 54 4f 4d 20 54 |........|CUSTOM T|
|00002c50| 52 49 47 47 45 52 20 46 | 4f 4f 54 45 52 00 00 00 |RIGGER F|OOTER...|
|00002c60| 00 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 15 |........|........|
|00002c70| 00 43 55 53 54 4f 4d 20 | 54 52 49 47 47 45 52 20 |.CUSTOM |TRIGGER |
|00002c80| 46 4f 4f 54 45 52 00 00 | 00 00 00 00 00 00 00 00 |FOOTER..|........|
|00002c90| 00 00 00 00 05 00 00 00 | 15 00 43 55 53 54 4f 4d |........|..CUSTOM|
|00002ca0| 20 54 52 49 47 47 45 52 | 20 46 4f 4f 54 45 52 00 | TRIGGER| FOOTER.|
|00002cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |........|........|
|00002cc0| 00 15 00 43 55 53 54 4f | 4d 20 54 52 49 47 47 45 |...CUSTO|M TRIGGE|
|00002cd0| 52 20 46 4f 4f 54 45 52 | 04 00 67 6f 0d 0a 2f 27 |R FOOTER|..go../'|
|00002ce0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 1b 00 |........|........|
|00002cf0| 43 55 53 54 4f 4d 20 54 | 52 49 47 47 45 52 20 44 |CUSTOM T|RIGGER D|
|00002d00| 45 46 41 55 4c 54 20 42 | 4f 44 59 7f 02 63 72 65 |EFAULT B|ODY..cre|
|00002d10| 61 74 65 20 74 72 69 67 | 67 65 72 20 25 54 72 69 |ate trig|ger %Tri|
|00002d20| 67 67 65 72 4e 61 6d 65 | 20 6f 6e 20 25 54 61 62 |ggerName| on %Tab|
|00002d30| 6c 65 4e 61 6d 65 0d 0a | 20 20 66 6f 72 20 25 41 |leName..|  for %A|
|00002d40| 63 74 69 6f 6e 73 28 22 | 2c 22 29 0d 0a 20 20 61 |ctions("|,")..  a|
|00002d50| 73 0d 0a 2f 2a 20 45 52 | 77 69 6e 20 42 75 69 6c |s../* ER|win Buil|
|00002d60| 74 69 6e 20 25 44 61 74 | 65 74 69 6d 65 20 2a 2f |tin %Dat|etime */|
|00002d70| 0d 0a 2f 2a 20 25 41 63 | 74 69 6f 6e 73 28 22 2c |../* %Ac|tions(",|
|00002d80| 22 29 20 74 72 69 67 67 | 65 72 20 6f 6e 20 25 54 |") trigg|er on %T|
|00002d90| 61 62 6c 65 4e 61 6d 65 | 20 2a 2f 0d 0a 2f 2a 20 |ableName| */../* |
|00002da0| 64 65 66 61 75 6c 74 20 | 62 6f 64 79 20 66 6f 72 |default |body for|
|00002db0| 20 25 54 72 69 67 67 65 | 72 4e 61 6d 65 20 2a 2f | %Trigge|rName */|
|00002dc0| 0d 0a 62 65 67 69 6e 0d | 0a 20 20 64 65 63 6c 61 |..begin.|.  decla|
|00002dd0| 72 65 20 20 40 6e 75 6d | 72 6f 77 73 20 69 6e 74 |re  @num|rows int|
|00002de0| 2c 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 40 6e |,..     |      @n|
|00002df0| 75 6c 6c 63 6e 74 20 69 | 6e 74 2c 0d 0a 20 20 20 |ullcnt i|nt,..   |
|00002e00| 20 20 20 20 20 20 20 20 | 40 76 61 6c 69 64 63 6e |        |@validcn|
|00002e10| 74 20 69 6e 74 2c 0d 0a | 20 20 20 20 20 20 20 20 |t int,..|        |
|00002e20| 20 20 20 25 50 4b 44 65 | 63 6c 28 2c 40 69 6e 73 |   %PKDe|cl(,@ins|
|00002e30| 29 25 64 65 63 6c 28 62 | 43 6f 6d 6d 61 2c 30 29 |)%decl(b|Comma,0)|
|00002e40| 25 46 6f 72 45 61 63 68 | 41 74 74 28 29 20 7b 25 |%ForEach|Att() {%|
|00002e50| 69 66 28 25 41 74 74 49 | 73 50 6b 29 20 7b 25 3d |if(%AttI|sPk) {%=|
|00002e60| 28 62 43 6f 6d 6d 61 2c | 31 29 7d 20 7d 25 69 66 |(bComma,|1)} }%if|
|00002e70| 20 28 25 3d 3d 28 25 3a | 62 43 6f 6d 6d 61 2c 31 | (%==(%:|bComma,1|
|00002e80| 29 29 20 7b 2c 7d 0d 0a | 20 20 20 20 20 20 20 20 |)) {,}..|        |
|00002e90| 20 20 20 40 65 72 72 6e | 6f 20 20 20 69 6e 74 2c |   @errn|o   int,|
|00002ea0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 40 65 72 |..      |     @er|
|00002eb0| 72 6d 73 67 20 20 76 61 | 72 63 68 61 72 28 32 35 |rmsg  va|rchar(25|
|00002ec0| 35 29 0d 0a 0d 0a 20 20 | 73 65 6c 65 63 74 20 40 |5)....  |select @|
|00002ed0| 6e 75 6d 72 6f 77 73 20 | 3d 20 40 40 72 6f 77 63 |numrows |= @@rowc|
|00002ee0| 6f 75 6e 74 0d 0a 25 46 | 6f 72 45 61 63 68 43 68 |ount..%F|orEachCh|
|00002ef0| 69 6c 64 52 65 6c 28 29 | 20 7b 0d 0a 20 20 25 52 |ildRel()| {..  %R|
|00002f00| 65 6c 54 65 6d 70 6c 61 | 74 65 0d 0a 7d 0d 0a 25 |elTempla|te..}..%|
|00002f10| 46 6f 72 45 61 63 68 50 | 61 72 65 6e 74 52 65 6c |ForEachP|arentRel|
|00002f20| 28 29 20 7b 0d 0a 20 20 | 25 52 65 6c 54 65 6d 70 |() {..  |%RelTemp|
|00002f30| 6c 61 74 65 0d 0a 7d 0d | 0a 20 20 72 65 74 75 72 |late..}.|.  retur|
|00002f40| 6e 0d 0a 65 72 72 6f 72 | 3a 0d 0a 20 20 20 20 72 |n..error|:..    r|
|00002f50| 61 69 73 65 72 72 6f 72 | 20 40 65 72 72 6e 6f 20 |aiserror| @errno |
|00002f60| 40 65 72 72 6d 73 67 0d | 0a 20 20 20 20 72 6f 6c |@errmsg.|.    rol|
|00002f70| 6c 62 61 63 6b 20 74 72 | 61 6e 73 61 63 74 69 6f |lback tr|ansactio|
|00002f80| 6e 0d 0a 65 6e 64 0d 0a | 67 6f 0d 0a 30 27 00 00 |n..end..|go..0'..|
|00002f90| 00 00 00 00 00 00 00 00 | 05 00 00 00 19 00 50 41 |........|......PA|
|00002fa0| 52 45 4e 54 20 55 50 44 | 41 54 45 20 53 45 54 20 |RENT UPD|ATE SET |
|00002fb0| 44 45 46 41 55 4c 54 92 | 00 2f 2a 20 45 52 77 69 |DEFAULT.|./* ERwi|
|00002fc0| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00002fd0| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 50 61 72 65 |ime */..|/* %Pare|
|00002fe0| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00002ff0| 43 68 69 6c 64 20 4f 4e | 20 50 41 52 45 4e 54 20 |Child ON| PARENT |
|00003000| 55 50 44 41 54 45 20 53 | 45 54 20 44 45 46 41 55 |UPDATE S|ET DEFAU|
|00003010| 4c 54 20 2a 2f 0d 0a 2f | 2a 20 41 70 70 6c 69 63 |LT */../|* Applic|
|00003020| 61 74 69 6f 6e 20 73 70 | 65 63 69 66 69 63 2e 20 |ation sp|ecific. |
|00003030| 20 4c 65 66 74 20 6f 75 | 74 20 69 6e 74 65 6e 74 | Left ou|t intent|
|00003040| 69 6f 6e 61 6c 6c 79 2e | 20 2a 2f 13 27 00 00 00 |ionally.| */.'...|
|00003050| 00 00 00 00 00 00 00 05 | 00 00 00 19 00 50 41 52 |........|.....PAR|
|00003060| 45 4e 54 20 44 45 4c 45 | 54 45 20 53 45 54 20 44 |ENT DELE|TE SET D|
|00003070| 45 46 41 55 4c 54 92 00 | 2f 2a 20 45 52 77 69 6e |EFAULT..|/* ERwin|
|00003080| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00003090| 6d 65 20 2a 2f 0d 0a 2f | 2a 20 25 50 61 72 65 6e |me */../|* %Paren|
|000030a0| 74 20 25 56 65 72 62 50 | 68 72 61 73 65 20 25 43 |t %VerbP|hrase %C|
|000030b0| 68 69 6c 64 20 4f 4e 20 | 50 41 52 45 4e 54 20 44 |hild ON |PARENT D|
|000030c0| 45 4c 45 54 45 20 53 45 | 54 20 44 45 46 41 55 4c |ELETE SE|T DEFAUL|
|000030d0| 54 20 2a 2f 0d 0a 2f 2a | 20 41 70 70 6c 69 63 61 |T */../*| Applica|
|000030e0| 74 69 6f 6e 20 73 70 65 | 63 69 66 69 63 2e 20 20 |tion spe|cific.  |
|000030f0| 4c 65 66 74 20 6f 75 74 | 20 69 6e 74 65 6e 74 69 |Left out| intenti|
|00003100| 6f 6e 61 6c 6c 79 2e 20 | 2a 2f 17 27 00 00 00 00 |onally. |*/.'....|
|00003110| 00 00 00 00 00 00 05 00 | 00 00 19 00 50 41 52 45 |........|....PARE|
|00003120| 4e 54 20 49 4e 53 45 52 | 54 20 53 45 54 20 44 45 |NT INSER|T SET DE|
|00003130| 46 41 55 4c 54 92 00 2f | 2a 20 45 52 77 69 6e 20 |FAULT../|* ERwin |
|00003140| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00003150| 65 20 2a 2f 0d 0a 2f 2a | 20 25 50 61 72 65 6e 74 |e */../*| %Parent|
|00003160| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00003170| 69 6c 64 20 4f 4e 20 50 | 41 52 45 4e 54 20 49 4e |ild ON P|ARENT IN|
|00003180| 53 45 52 54 20 53 45 54 | 20 44 45 46 41 55 4c 54 |SERT SET| DEFAULT|
|00003190| 20 2a 2f 0d 0a 2f 2a 20 | 41 70 70 6c 69 63 61 74 | */../* |Applicat|
|000031a0| 69 6f 6e 20 73 70 65 63 | 69 66 69 63 2e 20 20 4c |ion spec|ific.  L|
|000031b0| 65 66 74 20 6f 75 74 20 | 69 6e 74 65 6e 74 69 6f |eft out |intentio|
|000031c0| 6e 61 6c 6c 79 2e 20 2a | 2f 27 27 00 00 00 00 00 |nally. *|/''.....|
|000031d0| 00 00 00 00 00 05 00 00 | 00 18 00 43 48 49 4c 44 |........|...CHILD|
|000031e0| 20 49 4e 53 45 52 54 20 | 53 45 54 20 44 45 46 41 | INSERT |SET DEFA|
|000031f0| 55 4c 54 91 00 2f 2a 20 | 45 52 77 69 6e 20 42 75 |ULT../* |ERwin Bu|
|00003200| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|00003210| 2a 2f 0d 0a 2f 2a 20 25 | 50 61 72 65 6e 74 20 25 |*/../* %|Parent %|
|00003220| 56 65 72 62 50 68 72 61 | 73 65 20 25 43 68 69 6c |VerbPhra|se %Chil|
|00003230| 64 20 4f 4e 20 43 48 49 | 4c 44 20 49 4e 53 45 52 |d ON CHI|LD INSER|
|00003240| 54 20 53 45 54 20 44 45 | 46 41 55 4c 54 20 2a 2f |T SET DE|FAULT */|
|00003250| 0d 0a 2f 2a 20 41 70 70 | 6c 69 63 61 74 69 6f 6e |../* App|lication|
|00003260| 20 73 70 65 63 69 66 69 | 63 2e 20 20 4c 65 66 74 | specifi|c.  Left|
|00003270| 20 6f 75 74 20 69 6e 74 | 65 6e 74 69 6f 6e 61 6c | out int|entional|
|00003280| 6c 79 2e 20 2a 2f 1b 27 | 00 00 00 00 00 00 00 00 |ly. */.'|........|
|00003290| 00 00 05 00 00 00 18 00 | 43 48 49 4c 44 20 55 50 |........|CHILD UP|
|000032a0| 44 41 54 45 20 53 45 54 | 20 44 45 46 41 55 4c 54 |DATE SET| DEFAULT|
|000032b0| 91 00 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |../* ERw|in Built|
|000032c0| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|000032d0| 0a 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 |./* %Par|ent %Ver|
|000032e0| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|000032f0| 4e 20 43 48 49 4c 44 20 | 55 50 44 41 54 45 20 53 |N CHILD |UPDATE S|
|00003300| 45 54 20 44 45 46 41 55 | 4c 54 20 2a 2f 0d 0a 2f |ET DEFAU|LT */../|
|00003310| 2a 20 41 70 70 6c 69 63 | 61 74 69 6f 6e 20 73 70 |* Applic|ation sp|
|00003320| 65 63 69 66 69 63 2e 20 | 20 4c 65 66 74 20 6f 75 |ecific. | Left ou|
|00003330| 74 20 69 6e 74 65 6e 74 | 69 6f 6e 61 6c 6c 79 2e |t intent|ionally.|
|00003340| 20 2a 2f 1f 27 00 00 00 | 00 00 00 00 00 00 00 05 | */.'...|........|
|00003350| 00 00 00 18 00 43 48 49 | 4c 44 20 44 45 4c 45 54 |.....CHI|LD DELET|
|00003360| 45 20 53 45 54 20 44 45 | 46 41 55 4c 54 91 00 2f |E SET DE|FAULT../|
|00003370| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00003380| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 2f 2a |%Datetim|e */../*|
|00003390| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|000033a0| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 43 |rase %Ch|ild ON C|
|000033b0| 48 49 4c 44 20 44 45 4c | 45 54 45 20 53 45 54 20 |HILD DEL|ETE SET |
|000033c0| 44 45 46 41 55 4c 54 20 | 2a 2f 0d 0a 2f 2a 20 41 |DEFAULT |*/../* A|
|000033d0| 70 70 6c 69 63 61 74 69 | 6f 6e 20 73 70 65 63 69 |pplicati|on speci|
|000033e0| 66 69 63 2e 20 20 4c 65 | 66 74 20 6f 75 74 20 69 |fic.  Le|ft out i|
|000033f0| 6e 74 65 6e 74 69 6f 6e | 61 6c 6c 79 2e 20 2a 2f |ntention|ally. */|
|00003400| 23 27 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |#'......|........|
|00003410| 15 00 43 48 49 4c 44 20 | 44 45 4c 45 54 45 20 53 |..CHILD |DELETE S|
|00003420| 45 54 20 4e 55 4c 4c 8e | 00 2f 2a 20 45 52 77 69 |ET NULL.|./* ERwi|
|00003430| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00003440| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 50 61 72 65 |ime */..|/* %Pare|
|00003450| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00003460| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 44 |Child ON| CHILD D|
|00003470| 45 4c 45 54 45 20 53 45 | 54 20 4e 55 4c 4c 20 2a |ELETE SE|T NULL *|
|00003480| 2f 0d 0a 2f 2a 20 41 70 | 70 6c 69 63 61 74 69 6f |/../* Ap|plicatio|
|00003490| 6e 20 73 70 65 63 69 66 | 69 63 2e 20 20 4c 65 66 |n specif|ic.  Lef|
|000034a0| 74 20 6f 75 74 20 69 6e | 74 65 6e 74 69 6f 6e 61 |t out in|tentiona|
|000034b0| 6c 6c 79 2e 20 2a 2f 22 | 27 00 00 00 00 00 00 00 |lly. */"|'.......|
|000034c0| 00 00 00 05 00 00 00 16 | 00 50 41 52 45 4e 54 20 |........|.PARENT |
|000034d0| 49 4e 53 45 52 54 20 53 | 45 54 20 4e 55 4c 4c 8f |INSERT S|ET NULL.|
|000034e0| 00 2f 2a 20 45 52 77 69 | 6e 20 42 75 69 6c 74 69 |./* ERwi|n Builti|
|000034f0| 6e 20 25 44 61 74 65 74 | 69 6d 65 20 2a 2f 0d 0a |n %Datet|ime */..|
|00003500| 2f 2a 20 25 50 61 72 65 | 6e 74 20 25 56 65 72 62 |/* %Pare|nt %Verb|
|00003510| 50 68 72 61 73 65 20 25 | 43 68 69 6c 64 20 4f 4e |Phrase %|Child ON|
|00003520| 20 50 41 52 45 4e 54 20 | 49 4e 53 45 52 54 20 53 | PARENT |INSERT S|
|00003530| 45 54 20 4e 55 4c 4c 20 | 2a 2f 0d 0a 2f 2a 20 41 |ET NULL |*/../* A|
|00003540| 70 70 6c 69 63 61 74 69 | 6f 6e 20 73 70 65 63 69 |pplicati|on speci|
|00003550| 66 69 63 2e 20 20 4c 65 | 66 74 20 6f 75 74 20 69 |fic.  Le|ft out i|
|00003560| 6e 74 65 6e 74 69 6f 6e | 61 6c 6c 79 2e 20 2a 2f |ntention|ally. */|
|00003570| 26 27 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |&'......|........|
|00003580| 15 00 50 41 52 45 4e 54 | 20 49 4e 53 45 52 54 20 |..PARENT| INSERT |
|00003590| 43 41 53 43 41 44 45 8e | 00 2f 2a 20 45 52 77 69 |CASCADE.|./* ERwi|
|000035a0| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|000035b0| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 50 61 72 65 |ime */..|/* %Pare|
|000035c0| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|000035d0| 43 68 69 6c 64 20 4f 4e | 20 50 41 52 45 4e 54 20 |Child ON| PARENT |
|000035e0| 49 4e 53 45 52 54 20 43 | 41 53 43 41 44 45 20 2a |INSERT C|ASCADE *|
|000035f0| 2f 0d 0a 2f 2a 20 41 70 | 70 6c 69 63 61 74 69 6f |/../* Ap|plicatio|
|00003600| 6e 20 73 70 65 63 69 66 | 69 63 2e 20 20 4c 65 66 |n specif|ic.  Lef|
|00003610| 74 20 6f 75 74 20 69 6e | 74 65 6e 74 69 6f 6e 61 |t out in|tentiona|
|00003620| 6c 6c 79 2e 20 2a 2f 25 | 27 00 00 00 00 00 00 00 |lly. */%|'.......|
|00003630| 00 00 00 02 00 00 00 03 | 00 0d 00 54 65 6d 70 6c |........|...Templ|
|00003640| 61 74 65 20 4e 61 6d 65 | 22 00 00 00 00 02 00 0f |ate Name|".......|
|00003650| 00 54 65 6d 70 6c 61 74 | 65 20 48 61 6e 64 6c 65 |.Templat|e Handle|
|00003660| 00 00 00 00 00 00 00 00 | 00 03 00 00 00 01 00 0c |........|........|
|00003670| 00 50 75 72 70 6f 73 65 | 20 54 65 78 74 22 00 00 |.Purpose| Text"..|
|00003680| 00 00 00 00 07 00 50 75 | 72 70 6f 73 65 00 00 00 |......Pu|rpose...|
|00003690| 00 00 02 00 0f 00 54 65 | 6d 70 6c 61 74 65 20 48 |......Te|mplate H|
|000036a0| 61 6e 64 6c 65 22 00 00 | 00 00 22 00 00 00 03 00 |andle"..|..".....|
|000036b0| 00 00 14 00 43 48 49 4c | 44 20 44 45 4c 45 54 45 |....CHIL|D DELETE|
|000036c0| 20 43 41 53 43 41 44 45 | 21 27 00 00 21 27 ff ff | CASCADE|!'..!'..|
|000036d0| 03 00 00 00 15 00 43 48 | 49 4c 44 20 44 45 4c 45 |......CH|ILD DELE|
|000036e0| 54 45 20 52 45 53 54 52 | 49 43 54 20 27 00 00 20 |TE RESTR|ICT '.. |
|000036f0| 27 ff ff 03 00 00 00 18 | 00 43 48 49 4c 44 20 44 |'.......|.CHILD D|
|00003700| 45 4c 45 54 45 20 53 45 | 54 20 44 45 46 41 55 4c |ELETE SE|T DEFAUL|
|00003710| 54 23 27 00 00 23 27 ff | ff 03 00 00 00 15 00 43 |T#'..#'.|.......C|
|00003720| 48 49 4c 44 20 44 45 4c | 45 54 45 20 53 45 54 20 |HILD DEL|ETE SET |
|00003730| 4e 55 4c 4c 22 27 00 00 | 22 27 ff ff 03 00 00 00 |NULL"'..|"'......|
|00003740| 14 00 43 48 49 4c 44 20 | 49 4e 53 45 52 54 20 43 |..CHILD |INSERT C|
|00003750| 41 53 43 41 44 45 19 27 | 00 00 19 27 ff ff 03 00 |ASCADE.'|...'....|
|00003760| 00 00 15 00 43 48 49 4c | 44 20 49 4e 53 45 52 54 |....CHIL|D INSERT|
|00003770| 20 52 45 53 54 52 49 43 | 54 18 27 00 00 18 27 ff | RESTRIC|T.'...'.|
|00003780| ff 03 00 00 00 18 00 43 | 48 49 4c 44 20 49 4e 53 |.......C|HILD INS|
|00003790| 45 52 54 20 53 45 54 20 | 44 45 46 41 55 4c 54 1b |ERT SET |DEFAULT.|
|000037a0| 27 00 00 1b 27 ff ff 03 | 00 00 00 15 00 43 48 49 |'...'...|.....CHI|
|000037b0| 4c 44 20 49 4e 53 45 52 | 54 20 53 45 54 20 4e 55 |LD INSER|T SET NU|
|000037c0| 4c 4c 1a 27 00 00 1a 27 | ff ff 03 00 00 00 14 00 |LL.'...'|........|
|000037d0| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 43 41 53 |CHILD UP|DATE CAS|
|000037e0| 43 41 44 45 1d 27 00 00 | 1d 27 ff ff 03 00 00 00 |CADE.'..|.'......|
|000037f0| 15 00 43 48 49 4c 44 20 | 55 50 44 41 54 45 20 52 |..CHILD |UPDATE R|
|00003800| 45 53 54 52 49 43 54 1c | 27 00 00 1c 27 ff ff 03 |ESTRICT.|'...'...|
|00003810| 00 00 00 18 00 43 48 49 | 4c 44 20 55 50 44 41 54 |.....CHI|LD UPDAT|
|00003820| 45 20 53 45 54 20 44 45 | 46 41 55 4c 54 1f 27 00 |E SET DE|FAULT.'.|
|00003830| 00 1f 27 ff ff 03 00 00 | 00 15 00 43 48 49 4c 44 |..'.....|...CHILD|
|00003840| 20 55 50 44 41 54 45 20 | 53 45 54 20 4e 55 4c 4c | UPDATE |SET NULL|
|00003850| 1e 27 00 00 1e 27 ff ff | 03 00 00 00 1b 00 43 55 |.'...'..|......CU|
|00003860| 53 54 4f 4d 20 54 52 49 | 47 47 45 52 20 44 45 46 |STOM TRI|GGER DEF|
|00003870| 41 55 4c 54 20 42 4f 44 | 59 30 27 00 00 30 27 ff |AULT BOD|Y0'..0'.|
|00003880| ff 03 00 00 00 15 00 43 | 55 53 54 4f 4d 20 54 52 |.......C|USTOM TR|
|00003890| 49 47 47 45 52 20 46 4f | 4f 54 45 52 2f 27 00 00 |IGGER FO|OTER/'..|
|000038a0| 2f 27 ff ff 03 00 00 00 | 15 00 43 55 53 54 4f 4d |/'......|..CUSTOM|
|000038b0| 20 54 52 49 47 47 45 52 | 20 48 45 41 44 45 52 2e | TRIGGER| HEADER.|
|000038c0| 27 00 00 2e 27 ff ff 03 | 00 00 00 15 00 50 41 52 |'...'...|.....PAR|
|000038d0| 45 4e 54 20 44 45 4c 45 | 54 45 20 43 41 53 43 41 |ENT DELE|TE CASCA|
|000038e0| 44 45 15 27 00 00 15 27 | ff ff 03 00 00 00 16 00 |DE.'...'|........|
|000038f0| 50 41 52 45 4e 54 20 44 | 45 4c 45 54 45 20 52 45 |PARENT D|ELETE RE|
|00003900| 53 54 52 49 43 54 14 27 | 00 00 14 27 ff ff 03 00 |STRICT.'|...'....|
|00003910| 00 00 19 00 50 41 52 45 | 4e 54 20 44 45 4c 45 54 |....PARE|NT DELET|
|00003920| 45 20 53 45 54 20 44 45 | 46 41 55 4c 54 17 27 00 |E SET DE|FAULT.'.|
|00003930| 00 17 27 ff ff 03 00 00 | 00 16 00 50 41 52 45 4e |..'.....|...PAREN|
|00003940| 54 20 44 45 4c 45 54 45 | 20 53 45 54 20 4e 55 4c |T DELETE| SET NUL|
|00003950| 4c 16 27 00 00 16 27 ff | ff 03 00 00 00 15 00 50 |L.'...'.|.......P|
|00003960| 41 52 45 4e 54 20 49 4e | 53 45 52 54 20 43 41 53 |ARENT IN|SERT CAS|
|00003970| 43 41 44 45 25 27 00 00 | 25 27 ff ff 03 00 00 00 |CADE%'..|%'......|
|00003980| 16 00 50 41 52 45 4e 54 | 20 49 4e 53 45 52 54 20 |..PARENT| INSERT |
|00003990| 52 45 53 54 52 49 43 54 | 24 27 00 00 24 27 ff ff |RESTRICT|$'..$'..|
|000039a0| 03 00 00 00 19 00 50 41 | 52 45 4e 54 20 49 4e 53 |......PA|RENT INS|
|000039b0| 45 52 54 20 53 45 54 20 | 44 45 46 41 55 4c 54 27 |ERT SET |DEFAULT'|
|000039c0| 27 00 00 27 27 ff ff 03 | 00 00 00 16 00 50 41 52 |'..''...|.....PAR|
|000039d0| 45 4e 54 20 49 4e 53 45 | 52 54 20 53 45 54 20 4e |ENT INSE|RT SET N|
|000039e0| 55 4c 4c 26 27 00 00 26 | 27 ff ff 03 00 00 00 15 |ULL&'..&|'.......|
|000039f0| 00 50 41 52 45 4e 54 20 | 55 50 44 41 54 45 20 43 |.PARENT |UPDATE C|
|00003a00| 41 53 43 41 44 45 11 27 | 00 00 11 27 ff ff 03 00 |ASCADE.'|...'....|
|00003a10| 00 00 16 00 50 41 52 45 | 4e 54 20 55 50 44 41 54 |....PARE|NT UPDAT|
|00003a20| 45 20 52 45 53 54 52 49 | 43 54 10 27 00 00 10 27 |E RESTRI|CT.'...'|
|00003a30| ff ff 03 00 00 00 19 00 | 50 41 52 45 4e 54 20 55 |........|PARENT U|
|00003a40| 50 44 41 54 45 20 53 45 | 54 20 44 45 46 41 55 4c |PDATE SE|T DEFAUL|
|00003a50| 54 13 27 00 00 13 27 ff | ff 03 00 00 00 16 00 50 |T.'...'.|.......P|
|00003a60| 41 52 45 4e 54 20 55 50 | 44 41 54 45 20 53 45 54 |ARENT UP|DATE SET|
|00003a70| 20 4e 55 4c 4c 12 27 00 | 00 12 27 ff ff 03 00 00 | NULL.'.|..'.....|
|00003a80| 00 14 00 52 41 49 53 45 | 20 45 58 43 45 50 54 49 |...RAISE| EXCEPTI|
|00003a90| 4f 4e 20 50 52 4f 43 31 | 27 00 00 00 00 ff ff 03 |ON PROC1|'.......|
|00003aa0| 00 00 00 15 00 54 52 49 | 47 47 45 52 20 44 45 4c |.....TRI|GGER DEL|
|00003ab0| 45 54 45 20 46 4f 4f 54 | 45 52 2b 27 00 00 2b 27 |ETE FOOT|ER+'..+'|
|00003ac0| ff ff 03 00 00 00 15 00 | 54 52 49 47 47 45 52 20 |........|TRIGGER |
|00003ad0| 44 45 4c 45 54 45 20 48 | 45 41 44 45 52 2a 27 00 |DELETE H|EADER*'.|
|00003ae0| 00 2a 27 ff ff 03 00 00 | 00 15 00 54 52 49 47 47 |.*'.....|...TRIGG|
|00003af0| 45 52 20 49 4e 53 45 52 | 54 20 46 4f 4f 54 45 52 |ER INSER|T FOOTER|
|00003b00| 2d 27 00 00 2d 27 ff ff | 03 00 00 00 15 00 54 52 |-'..-'..|......TR|
|00003b10| 49 47 47 45 52 20 49 4e | 53 45 52 54 20 48 45 41 |IGGER IN|SERT HEA|
|00003b20| 44 45 52 2c 27 00 00 2c | 27 ff ff 03 00 00 00 15 |DER,'..,|'.......|
|00003b30| 00 54 52 49 47 47 45 52 | 20 55 50 44 41 54 45 20 |.TRIGGER| UPDATE |
|00003b40| 46 4f 4f 54 45 52 29 27 | 00 00 29 27 ff ff 03 00 |FOOTER)'|..)'....|
|00003b50| 00 00 15 00 54 52 49 47 | 47 45 52 20 55 50 44 41 |....TRIG|GER UPDA|
|00003b60| 54 45 20 48 45 41 44 45 | 52 28 27 00 00 28 27 ff |TE HEADE|R('..('.|
|00003b70| ff 06 00 00 00 01 00 00 | 00 23 00 00 00 00 01 00 |........|.#......|
|00003b80| 00 00 40 00 00 00 00 00 | 00 00 00 09 00 00 00 00 |..@.....|........|
|00003b90| 04 00 00 00 00 00 00 00 | 00 04 00 00 00 00 00 00 |........|........|
|00003ba0| 00 00 02 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00003bb0| 00 00 00 02 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bc0| 06 00 00 00 01 00 00 00 | 23 00 00 00 00 01 00 00 |........|#.......|
|00003bd0| 00 40 00 00 00 00 00 00 | 00 00 09 00 00 00 00 04 |.@......|........|
|00003be0| 00 00 00 00 00 00 00 00 | 04 00 00 00 00 00 00 00 |........|........|
|00003bf0| 00 02 00 00 00 00 00 00 | 00 00 00 00 00 00 06 00 |........|........|
|00003c00| 00 00 01 00 00 00 1a 00 | 00 00 00 01 00 00 00 40 |........|.......@|
|00003c10| 00 00 00 00 00 00 00 00 | 09 00 00 00 00 04 00 00 |........|........|
|00003c20| 00 00 00 00 00 00 04 00 | 00 00 00 00 00 00 00 02 |........|........|
|00003c30| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00003c40| 02 00 00 00 00 00 00 00 | 00 00 00 00 00 06 00 00 |........|........|
|00003c50| 00 01 00 00 00 1a 00 00 | 00 00 01 00 00 00 40 00 |........|......@.|
|00003c60| 00 00 00 00 00 00 00 09 | 00 00 00 00 04 00 00 00 |........|........|
|00003c70| 00 00 00 00 00 04 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|00003c80| 00 00 00 00 00 00 00 00 | 00 00 00 10 27 14 27 18 |........|....'.'.|
|00003c90| 27 1c 27 00 00 00 00 00 | 00 12 27 16 27 1a 27 1e |'.'.....|..'.'.'.|
|00003ca0| 27 00 00 00 00 00 00 10 | 27 14 27 18 27 1c 27 00 |'.......|'.'.'.'.|
|00003cb0| 00 00 00 00 00 11 27 15 | 27 18 27 1c 27 00 00 00 |......'.|'.'.'...|
|00003cc0| 00 00 00 07 00 00 00 01 | 00 00 00 00 00 00 00 00 |........|........|
|00003cd0| 04 00 00 00 00 00 00 00 | 00 02 00 00 00 00 00 00 |........|........|
|00003ce0| 00 00 02 00 00 00 00 00 | 00 00 00 02 00 00 00 00 |........|........|
|00003cf0| 00 00 00 00 04 00 00 00 | 00 00 00 00 00 04 00 00 |........|........|
|00003d00| 00 00 00 00 00 00 08 00 | 00 00 00 00 00 00 07 00 |........|........|
|00003d10| 00 00 16 00 44 65 66 61 | 75 6c 74 20 3c 75 6e 6b |....Defa|ult <unk|
|00003d20| 6e 6f 77 6e 3e 20 49 63 | 6f 6e e8 04 00 00 28 00 |nown> Ic|on....(.|
|00003d30| 00 00 10 00 00 00 0c 00 | 00 00 01 00 08 00 00 00 |........|........|
|00003d40| 00 00 c0 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00003d60| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|00003d70| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|00003d80| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00003d90| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00003da0| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00003db0| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|00003dc0| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|00003dd0| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00003de0| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00003df0| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00003e00| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|00003e10| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|00003e20| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00003e30| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00003e40| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00003e50| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|00003e60| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|00003e70| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00003e80| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00003e90| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00003ea0| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|00003eb0| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|00003ec0| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00003ed0| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00003ee0| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00003ef0| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|00003f00| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|00003f10| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00003f20| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00003f30| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00003f40| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|00003f50| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|00003f60| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00003f70| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00003f80| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00003f90| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|00003fa0| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|00003fb0| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00003fc0| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00003fd0| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00003fe0| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|00003ff0| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|00004000| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00004010| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00004020| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00004030| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|00004040| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|00004050| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00004060| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00004070| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00004080| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|00004090| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|000040a0| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|000040b0| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|000040c0| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|000040d0| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 80 80 |........|........|
|000040e0| 00 00 c0 c0 c0 00 c0 dc | c0 00 f0 ca a6 00 f0 fb |........|........|
|000040f0| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00004100| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00004110| 00 00 ff ff ff 00 00 00 | 00 00 00 00 80 00 00 80 |........|........|
|00004120| 00 00 00 80 80 00 80 00 | 00 00 80 00 80 00 f0 fb |........|........|
|00004130| ff 00 a4 a0 a0 00 80 80 | 80 00 00 00 ff 00 00 ff |........|........|
|00004140| 00 00 00 ff ff 00 ff 00 | 00 00 ff 00 ff 00 ff ff |........|........|
|00004150| 00 00 ff ff ff 00 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00004160| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 10 10 13 |........|........|
|00004170| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 10 10 13 |........|........|
|00004180| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00004190| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 10 10 13 |........|........|
|000041a0| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 13 10 10 |........|........|
|000041b0| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 13 13 10 |........|........|
|000041c0| 10 13 13 13 13 13 13 13 | 13 13 13 10 10 13 13 10 |........|........|
|000041d0| 10 13 13 13 13 13 13 13 | 13 13 13 10 10 13 13 10 |........|........|
|000041e0| 10 13 13 13 13 13 13 13 | 13 13 13 13 10 10 10 10 |........|........|
|000041f0| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00004200| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00004210| 13 13 13 13 13 13 02 00 | 00 00 00 00 00 00 07 00 |........|........|
|00004220| 00 00 11 00 44 65 66 61 | 75 6c 74 20 42 6c 6f 62 |....Defa|ult Blob|
|00004230| 20 49 63 6f 6e 68 05 00 | 00 28 00 00 00 11 00 00 | Iconh..|.(......|
|00004240| 00 10 00 00 00 01 00 08 | 00 00 00 00 00 40 01 00 |........|.....@..|
|00004250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004260| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|00004270| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|00004280| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|00004290| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|000042a0| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|000042b0| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|000042c0| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|000042d0| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|000042e0| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|000042f0| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|00004300| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|00004310| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|00004320| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|00004330| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|00004340| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|00004350| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|00004360| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|00004370| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|00004380| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|00004390| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|000043a0| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|000043b0| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|000043c0| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|000043d0| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|000043e0| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|000043f0| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|00004400| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|00004410| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|00004420| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|00004430| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|00004440| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|00004450| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|00004460| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|00004470| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|00004480| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|00004490| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|000044a0| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|000044b0| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|000044c0| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|000044d0| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|000044e0| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|000044f0| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|00004500| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|00004510| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|00004520| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|00004530| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|00004540| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|00004550| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|00004560| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|00004570| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|00004580| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|00004590| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|000045a0| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|000045b0| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|000045c0| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|000045d0| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|000045e0| 00 80 00 00 00 80 00 80 | 00 80 80 00 00 c0 c0 c0 |........|........|
|000045f0| 00 c0 dc c0 00 f0 ca a6 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|00004600| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|00004610| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|00004620| 00 00 00 00 00 00 00 80 | 00 00 80 00 00 00 80 80 |........|........|
|00004630| 00 80 00 00 00 80 00 80 | 00 f0 fb ff 00 a4 a0 a0 |........|........|
|00004640| 00 80 80 80 00 00 00 ff | 00 00 ff 00 00 00 ff ff |........|........|
|00004650| 00 ff 00 00 00 ff 00 ff | 00 ff ff 00 00 ff ff ff |........|........|
|00004660| 00 13 13 13 13 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00004670| 13 13 00 00 00 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00004680| 13 13 13 13 13 13 00 00 | 00 13 13 13 13 13 13 13 |........|........|
|00004690| 13 13 13 13 13 13 13 13 | 13 13 00 00 00 13 13 13 |........|........|
|000046a0| 13 13 00 00 00 00 13 13 | 13 13 13 13 13 13 00 00 |........|........|
|000046b0| 00 13 13 13 13 00 00 00 | 00 00 00 13 13 13 13 13 |........|........|
|000046c0| 13 13 00 00 00 13 13 13 | 00 00 00 00 00 00 00 00 |........|........|
|000046d0| 13 13 13 13 13 13 00 00 | 00 13 13 00 00 00 00 00 |........|........|
|000046e0| 00 00 00 00 00 13 13 13 | 13 13 00 00 00 13 13 00 |........|........|
|000046f0| 00 00 00 00 00 00 00 00 | 00 13 13 13 13 13 00 00 |........|........|
|00004700| 00 13 13 00 00 00 00 00 | 00 00 00 00 00 13 13 13 |........|........|
|00004710| 13 13 00 00 00 13 13 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004720| 00 13 13 13 13 13 00 00 | 00 13 13 13 00 00 00 00 |........|........|
|00004730| 00 00 00 00 13 13 13 13 | 13 13 00 00 00 13 13 13 |........|........|
|00004740| 13 00 00 00 00 00 00 13 | 13 13 13 13 13 13 00 00 |........|........|
|00004750| 00 13 13 13 13 13 00 00 | 00 00 13 13 13 13 13 13 |........|........|
|00004760| 13 13 00 00 00 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00004770| 13 13 13 13 13 13 00 00 | 00 13 13 13 13 13 13 13 |........|........|
|00004780| 13 13 13 13 13 13 13 13 | 13 13 00 00 00 13 13 13 |........|........|
|00004790| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 13 00 00 |........|........|
|000047a0| 00 04 00 00 00 00 00 00 | 00 07 00 00 00 15 00 44 |........|.......D|
|000047b0| 65 66 61 75 6c 74 20 44 | 61 74 65 74 69 6d 65 20 |efault D|atetime |
|000047c0| 49 63 6f 6e 18 05 00 00 | 28 00 00 00 10 00 00 00 |Icon....|(.......|
|000047d0| 0f 00 00 00 01 00 08 00 | 00 00 00 00 f0 00 00 00 |........|........|
|000047e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047f0| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|00004800| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|00004810| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|00004820| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|00004830| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|00004840| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|00004850| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|00004860| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|00004870| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|00004880| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|00004890| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|000048a0| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|000048b0| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|000048c0| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|000048d0| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|000048e0| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|000048f0| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|00004900| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|00004910| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|00004920| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|00004930| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|00004940| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|00004950| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|00004960| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|00004970| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|00004980| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|00004990| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|000049a0| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|000049b0| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|000049c0| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|000049d0| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|000049e0| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|000049f0| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|00004a00| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|00004a10| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|00004a20| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|00004a30| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|00004a40| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|00004a50| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|00004a60| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|00004a70| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|00004a80| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|00004a90| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|00004aa0| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|00004ab0| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|00004ac0| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|00004ad0| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|00004ae0| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|00004af0| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|00004b00| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|00004b10| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|00004b20| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|00004b30| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|00004b40| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|00004b50| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|00004b60| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|00004b70| 80 00 00 00 80 00 80 00 | 80 80 00 00 c0 c0 c0 00 |........|........|
|00004b80| c0 dc c0 00 f0 ca a6 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|00004b90| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|00004ba0| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|00004bb0| 00 00 00 00 00 00 80 00 | 00 80 00 00 00 80 80 00 |........|........|
|00004bc0| 80 00 00 00 80 00 80 00 | f0 fb ff 00 a4 a0 a0 00 |........|........|
|00004bd0| 80 80 80 00 00 00 ff 00 | 00 ff 00 00 00 ff ff 00 |........|........|
|00004be0| ff 00 00 00 ff 00 ff 00 | ff ff 00 00 ff ff ff 00 |........|........|
|00004bf0| 13 13 13 13 13 00 00 00 | 00 00 00 13 13 13 13 13 |........|........|
|00004c00| 13 13 13 01 01 0d 0d 0d | 0d 0d 0d 00 13 13 13 13 |........|........|
|00004c10| 13 13 13 0d 0d 0d 01 01 | 01 01 0d 0d 00 13 13 13 |........|........|
|00004c20| 13 13 01 0d 01 01 13 13 | 13 13 01 0d 0d 00 13 13 |........|........|
|00004c30| 13 01 0d 01 13 13 13 13 | 13 13 13 13 01 0d 00 13 |........|........|
|00004c40| 01 0d 0d 13 13 00 13 13 | 13 13 13 13 01 0d 0d 00 |........|........|
|00004c50| 01 0d 13 13 13 13 00 13 | 13 13 13 13 13 01 0d 00 |........|........|
|00004c60| 01 0d 13 13 13 13 13 04 | 04 04 04 13 13 01 0d 00 |........|........|
|00004c70| 01 0d 13 13 13 13 13 04 | 00 13 13 13 13 01 0d 00 |........|........|
|00004c80| 01 0d 13 13 13 13 13 04 | 13 00 13 13 13 01 0d 00 |........|........|
|00004c90| 01 0d 0d 13 13 13 13 04 | 13 13 13 13 01 0d 0d 00 |........|........|
|00004ca0| 13 01 0d 01 13 13 13 04 | 13 13 13 13 01 0d 00 13 |........|........|
|00004cb0| 13 13 01 0d 01 01 13 13 | 13 13 01 0d 0d 00 13 13 |........|........|
|00004cc0| 13 13 13 0d 0d 0d 01 01 | 01 01 0d 0d 00 13 13 13 |........|........|
|00004cd0| 13 13 13 01 01 0d 0d 0d | 0d 0d 0d 00 13 13 13 13 |........|........|
|00004ce0| 08 00 00 00 00 00 00 00 | 07 00 00 00 13 00 44 65 |........|......De|
|00004cf0| 66 61 75 6c 74 20 4e 75 | 6d 62 65 72 20 49 63 6f |fault Nu|mber Ico|
|00004d00| 6e 68 05 00 00 28 00 00 | 00 11 00 00 00 10 00 00 |nh...(..|........|
|00004d10| 00 01 00 08 00 00 00 00 | 00 40 01 00 00 00 00 00 |........|.@......|
|00004d20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004d30| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00004d40| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|00004d50| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00004d60| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00004d70| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|00004d80| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00004d90| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|00004da0| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00004db0| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00004dc0| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|00004dd0| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00004de0| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|00004df0| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00004e00| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00004e10| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|00004e20| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00004e30| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|00004e40| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00004e50| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00004e60| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|00004e70| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00004e80| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|00004e90| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00004ea0| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00004eb0| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|00004ec0| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00004ed0| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|00004ee0| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00004ef0| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00004f00| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|00004f10| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00004f20| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|00004f30| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00004f40| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00004f50| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|00004f60| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00004f70| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|00004f80| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00004f90| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00004fa0| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|00004fb0| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00004fc0| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|00004fd0| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00004fe0| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00004ff0| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|00005000| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00005010| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|00005020| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00005030| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00005040| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|00005050| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00005060| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|00005070| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00005080| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00005090| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|000050a0| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|000050b0| 00 80 00 80 00 80 80 00 | 00 c0 c0 c0 00 c0 dc c0 |........|........|
|000050c0| 00 f0 ca a6 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|000050d0| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|000050e0| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 00 00 00 |........|........|
|000050f0| 00 00 00 80 00 00 80 00 | 00 00 80 80 00 80 00 00 |........|........|
|00005100| 00 80 00 80 00 f0 fb ff | 00 a4 a0 a0 00 80 80 80 |........|........|
|00005110| 00 00 00 ff 00 00 ff 00 | 00 00 ff ff 00 ff 00 00 |........|........|
|00005120| 00 ff 00 ff 00 ff ff 00 | 00 ff ff ff 00 13 13 13 |........|........|
|00005130| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 13 00 00 |........|........|
|00005140| 00 13 13 13 13 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00005150| 13 13 00 00 00 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00005160| 13 13 13 13 13 13 00 00 | 00 13 13 13 13 13 13 13 |........|........|
|00005170| 13 13 13 13 13 13 13 13 | 13 13 00 00 00 13 13 10 |........|........|
|00005180| 10 13 10 10 13 13 10 10 | 13 10 10 13 13 13 00 00 |........|........|
|00005190| 00 13 13 10 10 13 10 10 | 13 13 10 10 13 10 10 13 |........|........|
|000051a0| 13 13 00 00 00 13 13 10 | 10 13 10 10 13 13 10 10 |........|........|
|000051b0| 13 10 10 13 13 13 00 00 | 00 13 10 10 10 10 10 10 |........|........|
|000051c0| 10 10 10 10 10 10 10 10 | 13 13 00 00 00 13 13 10 |........|........|
|000051d0| 10 13 10 10 13 13 10 10 | 13 10 10 13 13 13 00 00 |........|........|
|000051e0| 00 13 10 10 10 10 10 10 | 10 10 10 10 10 10 10 10 |........|........|
|000051f0| 13 13 00 00 00 13 13 10 | 10 13 10 10 13 13 10 10 |........|........|
|00005200| 13 10 10 13 13 13 00 00 | 00 13 13 10 10 13 10 10 |........|........|
|00005210| 13 13 10 10 13 10 10 13 | 13 13 00 00 00 13 13 10 |........|........|
|00005220| 10 13 10 10 13 13 10 10 | 13 10 10 13 13 13 00 00 |........|........|
|00005230| 00 13 13 13 13 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00005240| 13 13 00 00 00 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00005250| 13 13 13 13 13 13 00 00 | 00 13 13 13 13 13 13 13 |........|........|
|00005260| 13 13 13 13 13 13 13 13 | 13 13 00 00 00 10 00 00 |........|........|
|00005270| 00 00 00 00 00 07 00 00 | 00 13 00 44 65 66 61 75 |........|...Defau|
|00005280| 6c 74 20 53 74 72 69 6e | 67 20 49 63 6f 6e 68 05 |lt Strin|g Iconh.|
|00005290| 00 00 28 00 00 00 11 00 | 00 00 10 00 00 00 01 00 |..(.....|........|
|000052a0| 08 00 00 00 00 00 40 01 | 00 00 00 00 00 00 00 00 |......@.|........|
|000052b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052c0| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|000052d0| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|000052e0| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|000052f0| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00005300| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00005310| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00005320| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00005330| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00005340| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00005350| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00005360| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00005370| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00005380| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00005390| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|000053a0| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|000053b0| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|000053c0| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|000053d0| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|000053e0| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|000053f0| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00005400| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00005410| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00005420| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00005430| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00005440| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00005450| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00005460| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00005470| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00005480| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00005490| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|000054a0| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|000054b0| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|000054c0| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|000054d0| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|000054e0| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|000054f0| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00005500| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00005510| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00005520| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00005530| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00005540| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00005550| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00005560| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00005570| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00005580| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00005590| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|000055a0| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|000055b0| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|000055c0| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|000055d0| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|000055e0| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|000055f0| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00005600| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00005610| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00005620| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00005630| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00005640| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00005650| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00005660| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00005670| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00005680| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00005690| 80 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|000056a0| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|000056b0| ff 00 ff ff 00 00 ff ff | ff 00 13 13 13 13 13 13 |........|........|
|000056c0| 13 13 13 13 13 13 13 13 | 13 13 13 00 00 00 13 13 |........|........|
|000056d0| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 13 13 00 |........|........|
|000056e0| 00 00 13 13 13 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|000056f0| 13 13 13 00 00 00 13 13 | 13 13 13 13 07 07 07 07 |........|........|
|00005700| 07 13 13 13 13 13 13 00 | 00 00 13 13 13 13 13 13 |........|........|
|00005710| 07 04 04 04 07 07 13 13 | 13 13 13 00 00 00 13 13 |........|........|
|00005720| 13 13 13 07 07 04 07 07 | 04 07 07 13 13 13 13 00 |........|........|
|00005730| 00 00 13 04 07 07 07 04 | 07 04 07 07 04 07 07 07 |........|........|
|00005740| 07 13 13 00 00 00 13 04 | 07 07 07 04 07 04 07 07 |........|........|
|00005750| 04 07 04 04 07 07 13 00 | 00 00 13 04 04 04 04 04 |........|........|
|00005760| 07 04 04 04 07 04 07 07 | 04 07 13 00 00 00 13 13 |........|........|
|00005770| 04 07 04 07 07 04 07 07 | 07 04 07 07 07 07 13 00 |........|........|
|00005780| 00 00 13 13 04 07 04 07 | 07 04 07 07 07 04 07 07 |........|........|
|00005790| 04 07 13 00 00 00 13 13 | 04 07 04 07 07 07 07 07 |........|........|
|000057a0| 07 07 04 04 07 07 13 00 | 00 00 13 13 07 04 07 07 |........|........|
|000057b0| 13 13 13 13 13 07 07 07 | 07 13 13 00 00 00 13 13 |........|........|
|000057c0| 07 04 07 13 13 13 13 13 | 13 13 13 13 13 13 13 00 |........|........|
|000057d0| 00 00 13 13 07 07 07 13 | 13 13 13 13 13 13 13 13 |........|........|
|000057e0| 13 13 13 00 00 00 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|000057f0| 13 13 13 13 13 13 13 00 | 00 00 20 00 00 00 00 00 |........|.. .....|
|00005800| 00 00 07 00 00 00 13 00 | 44 65 66 61 75 6c 74 20 |........|Default |
|00005810| 45 6e 74 69 74 79 20 49 | 63 6f 6e e8 07 00 00 28 |Entity I|con....(|
|00005820| 00 00 00 1e 00 00 00 1e | 00 00 00 01 00 08 00 00 |........|........|
|00005830| 00 00 00 c0 03 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|00005850| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|00005860| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|00005870| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|00005880| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|00005890| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|000058a0| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|000058b0| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|000058c0| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|000058d0| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|000058e0| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|000058f0| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|00005900| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|00005910| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|00005920| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|00005930| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|00005940| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|00005950| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|00005960| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|00005970| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|00005980| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|00005990| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|000059a0| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|000059b0| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|000059c0| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|000059d0| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|000059e0| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|000059f0| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|00005a00| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|00005a10| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|00005a20| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|00005a30| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|00005a40| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|00005a50| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|00005a60| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|00005a70| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|00005a80| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|00005a90| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|00005aa0| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|00005ab0| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|00005ac0| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|00005ad0| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|00005ae0| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|00005af0| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|00005b00| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|00005b10| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|00005b20| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|00005b30| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|00005b40| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|00005b50| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|00005b60| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|00005b70| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|00005b80| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|00005b90| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|00005ba0| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|00005bb0| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|00005bc0| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 80 |........|........|
|00005bd0| 80 00 00 c0 c0 c0 00 c0 | dc c0 00 f0 ca a6 00 f0 |........|........|
|00005be0| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|00005bf0| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|00005c00| ff 00 00 ff ff ff 00 00 | 00 00 00 00 00 80 00 00 |........|........|
|00005c10| 80 00 00 00 80 80 00 80 | 00 00 00 80 00 80 00 f0 |........|........|
|00005c20| fb ff 00 a4 a0 a0 00 80 | 80 80 00 00 00 ff 00 00 |........|........|
|00005c30| ff 00 00 00 ff ff 00 ff | 00 00 00 ff 00 ff 00 ff |........|........|
|00005c40| ff 00 00 ff ff ff 00 07 | 07 0c 0c 0c 0c 0c 0c 0c |........|........|
|00005c50| 0c 0c 0c 0c 0c 0c 0c 0c | 0c 0c 0c 0c 0c 0c 0c 0c |........|........|
|00005c60| 0c 0c 0c 07 07 00 00 07 | 13 0c 0c 0c 0c 0c 0c 0c |........|........|
|00005c70| 0c 0c 0c 0c 0c 0c 0c 0c | 0c 0c 0c 0c 0c 0c 0c 0c |........|........|
|00005c80| 0c 0c 0c 0c 07 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005c90| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005ca0| 07 07 0c 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005cb0| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005cc0| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005cd0| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005ce0| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005cf0| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005d00| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005d10| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005d20| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005d30| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005d40| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005d50| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005d60| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005d70| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005d80| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005d90| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005da0| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005db0| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005dc0| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005dd0| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005de0| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005df0| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005e00| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005e10| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005e20| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005e30| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005e40| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005e50| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005e60| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005e70| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005e80| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005e90| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005ea0| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005eb0| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005ec0| 07 07 07 0c 0c 00 00 13 | 07 07 07 07 07 07 07 07 |........|........|
|00005ed0| 07 07 07 07 07 07 07 07 | 07 07 07 07 07 07 07 07 |........|........|
|00005ee0| 07 07 07 0c 0c 00 00 13 | 13 13 13 13 13 13 13 13 |........|........|
|00005ef0| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00005f00| 13 13 13 0c 0c 00 00 13 | 0c 0c 0c 0c 0c 0c 0c 0c |........|........|
|00005f10| 0c 0c 0c 0c 0c 0c 0c 0c | 0c 0c 0c 0c 0c 0c 0c 0c |........|........|
|00005f20| 0c 0c 0c 0c 0c 00 00 13 | 12 12 12 12 12 12 12 12 |........|........|
|00005f30| 12 12 12 12 12 12 12 12 | 12 12 12 12 12 12 12 12 |........|........|
|00005f40| 12 12 12 0c 0c 00 00 13 | 12 12 12 12 12 12 12 12 |........|........|
|00005f50| 12 12 12 12 12 12 12 12 | 12 12 12 12 12 12 12 12 |........|........|
|00005f60| 12 12 12 0c 0c 00 00 13 | 12 12 12 12 12 12 12 12 |........|........|
|00005f70| 12 12 12 12 12 12 12 12 | 12 12 12 12 12 12 12 12 |........|........|
|00005f80| 12 12 12 0c 0c 00 00 13 | 12 12 12 12 12 12 12 12 |........|........|
|00005f90| 12 12 12 12 12 12 12 12 | 12 12 12 12 12 12 12 12 |........|........|
|00005fa0| 12 12 12 0c 0c 00 00 13 | 12 12 12 12 12 12 12 12 |........|........|
|00005fb0| 12 12 12 12 12 12 12 12 | 12 12 12 12 12 12 12 12 |........|........|
|00005fc0| 12 12 0c 0c 0c 00 00 07 | 13 12 12 12 12 12 12 12 |........|........|
|00005fd0| 12 12 12 12 12 12 12 12 | 12 12 12 12 12 12 12 12 |........|........|
|00005fe0| 12 12 0c 0c 07 00 00 07 | 07 13 13 13 13 13 13 13 |........|........|
|00005ff0| 13 13 13 13 13 13 13 13 | 13 13 13 13 13 13 13 13 |........|........|
|00006000| 13 13 13 07 07 00 00 41 | 00 00 00 00 00 00 00 07 |.......A|........|
|00006010| 00 00 00 19 00 44 65 66 | 61 75 6c 74 20 45 6e 74 |.....Def|ault Ent|
|00006020| 69 74 79 20 53 6d 61 6c | 6c 20 49 63 6f 6e 68 05 |ity Smal|l Iconh.|
|00006030| 00 00 28 00 00 00 11 00 | 00 00 10 00 00 00 01 00 |..(.....|........|
|00006040| 08 00 00 00 00 00 40 01 | 00 00 00 00 00 00 00 00 |......@.|........|
|00006050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006060| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00006070| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00006080| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00006090| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|000060a0| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|000060b0| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|000060c0| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|000060d0| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|000060e0| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|000060f0| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00006100| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00006110| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00006120| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00006130| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00006140| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00006150| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00006160| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00006170| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00006180| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00006190| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|000061a0| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|000061b0| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|000061c0| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|000061d0| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|000061e0| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|000061f0| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00006200| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00006210| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00006220| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00006230| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00006240| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00006250| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00006260| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00006270| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00006280| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00006290| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|000062a0| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|000062b0| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|000062c0| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|000062d0| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|000062e0| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|000062f0| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00006300| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00006310| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00006320| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00006330| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00006340| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|00006350| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|00006360| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|00006370| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|00006380| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|00006390| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|000063a0| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
|000063b0| ff 00 00 ff 00 00 00 ff | ff 00 ff 00 00 00 ff 00 |........|........|
|000063c0| ff 00 ff ff 00 00 ff ff | ff 00 00 00 00 00 00 00 |........|........|
|000063d0| 80 00 00 80 00 00 00 80 | 80 00 80 00 00 00 80 00 |........|........|
|000063e0| 80 00 80 80 00 00 c0 c0 | c0 00 c0 dc c0 00 f0 ca |........|........|
|000063f0| a6 00 f0 fb ff 00 a4 a0 | a0 00 80 80 80 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+